As you know your website data is stored in your database server, in this case is MySQL. To prevent disaster, backup your data regularly is a must for you and every website owner. There are many ways to backup MySQL data, one of them is using mysqldump to dump your MySQL data to a file.But mysqldump output is plaint text files with full of SQL commands. And in linux you can compress it using gzip with pipelining command.To backup and compress MySQL dump file:Explanation: the … Read more...
Copy MySQL Data Across The Server
September 21, 2010 • Leave a Comment
If you move or change your hosting server, beside the files you also need to move your mysql data as well. MySQL database hold all your website data including content, configuration, user account and other thing. So please be careful with this data you need to backup it regularly. See my other post about how to regularly backup your mysql.But when you move to another server you can do it with 2 ways: 1. Backup it from the old server and upload it to another server You can do this with … Read more...
