One of the programming that is widely used in the world today is PHP. PHP bergembang so rapidly adopted in the content of websites that use CMS engine. For example, it is wordpress or joomla. Both CMS is largely using the MySQL database. MySQL is a database that we can use for free.
The most important thing when we use MySQL is a data backup. This backup should we do many times for our data remains secure, in the event of damage or loss of data due to hard drive because we do not know. Here is a brief article, how to use simple PHP script to perform backups of data in MySQL.
\u0026lt;? Php
$ dbname = "oci_parse";
$ dbhost = "localhost";
$ dbuser = "root";
$ dbpass = "******";
$ backupFile = "infokomtek_com" ;;
$ backupFile = $ dbname. date ("YmdHis"). '. Gz';
$ command = "mysqldump - opt-h $ dbhost-u $ dbuser-p $ dbpass $ dbname backups. $ Dbhost = "localhost" is the host name data base we are. $ Dbuser = "root" is a user to access the database. $ Dbpass = "******" is the password to access the database. Depending on your MySQL settings, sometimes it is not required a password to connect to MySQL.
The most important thing when we use MySQL is a data backup. This backup should we do many times for our data remains secure, in the event of damage or loss of data due to hard drive because we do not know. Here is a brief article, how to use simple PHP script to perform backups of data in MySQL.
\u0026lt;? Php
$ dbname = "oci_parse";
$ dbhost = "localhost";
$ dbuser = "root";
$ dbpass = "******";
$ backupFile = "infokomtek_com" ;;
$ backupFile = $ dbname. date ("YmdHis"). '. Gz';
$ command = "mysqldump - opt-h $ dbhost-u $ dbuser-p $ dbpass $ dbname backups. $ Dbhost = "localhost" is the host name data base we are. $ Dbuser = "root" is a user to access the database. $ Dbpass = "******" is the password to access the database. Depending on your MySQL settings, sometimes it is not required a password to connect to MySQL.
0 comments:
Post a Comment