free
This is our archive, please go to the main forum page for the latest discussions and news about free web hosting.


how to backup mysql data?

b
November 22nd, 2000, 04:46
i'm new to mysql. i downloaded the free version for vboard and i'm really suprised how esay it was to install.
i will buy the full version soon but i need to know how to backup the data. i added one forum and one subject but i can not find the data anywhere on my server. how do you backup the data? ftp would do or there is another way?
thanks

jvv
November 22nd, 2000, 05:15
You first need to make a dump of your database using the mysqldump command. For the exact use of this command check:

http://www.mysql.com/documentation/mysql/commented/manual.php?section=mysqldump

Then you should be able to download it.

perlboy
November 30th, 2000, 17:14
Just expanding on the other reply with regards to mysqldump. Execute it as follows.

mysqldump -u USERNAME -p DATABASENAME > backup.txt

Then download backup.txt as your database backup. Anything ever happens and you want to restore the backup.

mysql -u USERNAME -p DATABASENAME < backup.txt





  
  News · Search free hosts · Free file hosting · Free image hosting · Reviews · Forums · Related Links · Advertising Info · Contact Us


Copyright © 1996-2008 Per Olof Sandholm. All rights reserved. Privacy Statement

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum