MySQL Backup

[bnhcomputing]

I need to backup my MySQL database while it is in use. What is the recommended procedure / tool for backing up MySQL without shutting it down?

Thanks in advance,

Hubert Hoffman

 

[sleipnir214]

On Linux boxes, I generally use mysqlhotcopy, which is a perl script that locks the databases then copies the MySQL database files to another location.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[bnhcomputing]

Sorry for not being more specific.

Running on WIN2000, MySQL version 4.0.16-nt

Thanks,

Hubert

 

[hos2]

can't you just backup with phpmyadmin and the export function ?? it should not matter I think if users are connected or not

 

[bnhcomputing]

I am using MySQL in a client server environment with a VB client. I guess I'm more familiar with MS-SQL where a backup agent is used.

If I just copy the files, what happens if the files get out of sinc during the copy?

MySQL AB mentions an administration utility, but it doesn't look like this is available yet.

Can you give me more information about phpmyadmin or any other suggestions?

Thanks again,

Hubert

 

[lloydie2]

For administration try

http://www.mysqlfront.de

or you could try

http://www.mysql.com/downloads/mysqlcc.html.

MySqlFront 2.5 is better I think 3.0 beta has a few bugs.