Can any one tell me the procedure to backup mysql database. There is large amount of data stored in my database. Is that possible to Copy the raw mysql database files?
Printable View
Can any one tell me the procedure to backup mysql database. There is large amount of data stored in my database. Is that possible to Copy the raw mysql database files?
MySQL database backup can be accomplished in following ways : a) Copying the raw mysql database files & b) Exporting tables to text files or Execute a database backup query from PHP file. Run mysqldump using system() function. Use phpMyAdmin to do the backup.
Backup Database MySQL. Much more difficult is the task of creating a copy of such a dynamic structure, the database MySQL.Make a copy of all the static HTML-and other documents easily. It is also easy to periodically "put off to one side, and copies of scripts. Much more difficult is the task of creating a copy (the backup) of such a dynamic structure, the database MySQL.
There is a program mysqldump, allowing fast and easy to perform operations to create a backup database MySQL. Also mysqldump provides an opportunity to make very fine settings for managing backups of databases or individual tables. We can say that mysqldump - is a basic tool that you will need to use in the event that you do backup MySQL.