MySQL

Backup MySQL database using a batch file

Jan
10

Problem

I understand the earlier tutorial on how to back up a database, but now I want to incorporate it as part of a batch file to be run automatically AND I want to keep previous copies of the backups.

Solution

database-backup.bat

Posted By Brent read more

How do I restore a database from backup?

May
06

I use mysqldump to dump the entire structure and contents of a database into a SQL format file. Therefore all I need to do to restore this file is to execute the SQL contained therein. You might be able to import it directly into phpMyAdmin via the import process to restore a database, however if phpMyAdmin is not an option then you can restore from the command prompt utility.

Posted By Brent read more

How do I backup a database?

May
05

Providing you have set up your initialization file properly, all that you would need to do to backup your database is run the following command (on the command-line):

mysqldump myDatabase > myDatabase_backup.sql

This will dump your database as an SQL format into the file myDatabase_backup.sql.

Posted By Brent read more

What is the my.ini file used for?

May
05

my.ini is the initialization file used by MySQL when it loads. It is similar to php.ini for PHP, and can be modified to set common option values for your MySQL installation. Typically this file will be saved in your MySQL install directory, however you should take care not to copy it to other locations because MySQL will look for your initialization file in several different locations and may load those instead.

Posted By Brent read more
Posted By Brent read more
Subscribe to RSS - MySQL