The best way to make copies of your information in MySQL is to use a special command called ‘mysqldump’. This command helps you create a simple file that holds all the information in your database. You can use this file to move your data to another MySQL database that doesn’t have any information in it yet. This trick works on any Linux computer that has MySQL.
Here’s how to use the mysqldump command:
- First, you need to tell the computer your MySQL username, password, and the name of the database you want to copy. Then you also need to decide what to call your file. You can use this command:
mysqldump -u [username] –p[password] [database_name] > [dump_file.sql]
For example:
sudo mysqldump –single-transaction -u dbuser -p moodle > /home/robert/elearning_db.sql
After that, you can use another command to put this information back into another MySQL database. Here’s an example:
sudo mysql -u dbuser -p moodle < /home/robert/elearning_db.sql
If you want to put your information back into a database on your own computer, you can use the mysql command like this:
mysql -u [username] –p[password] [database_name] < [dump_file.sql]
· If you want to put your information back into a remote computer, you can use a similar command, but you need to add a special code to tell the computer where to find the other database. It looks like this:
mysql –h [hostname] –u [username] –p[password] [database_name] < [dump_file.sql]
If you use the right codes and the other computer is turned on, you can copy your information into the other database.