Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MySQL Administrator not backing up current database

Status
Not open for further replies.

isaacgrover

IS-IT--Management
Jun 13, 2006
54
Good evening from Wisconsin,

I recently came into managing a Windows 2003 server that has MySQL Administrator installed and supposedly running the MySQL databases for that server. We're trying to migrate the MySQL databases to a new server, but I can't seem to get the current data, only original data, using the MySQL Administrator built-in backup tool.

Is there another way to backup the current data?

Thank you in advance,


--
Isaac Grover, Owner
Quality Computer Services of River Falls, Wisconsin
Web:
 
try mysqldump

There are three general ways to invoke mysqldump:

shell> mysqldump [options] db_name [tbl_name ...]
shell> mysqldump [options] --databases db_name ...
shell> mysqldump [options] --all-databases

If you do not name any tables following db_name or if you use the --databases or --all-databases option, entire databases are dumped.

Norm
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top