http://tips.pair.com/index.php3?page=php3mysql_backupmysqldatabase
When use of the following examples replace
$host with hostname/IP of your MySQL server.
$user with your username
$pass with your password
$database with your databasename
$table with your table
How to make a mysqldump:
mysqldump -h$host -u$user -p$pass $database $table >
backup_table.sav
How to load the backup_table.sav into the database again:
First you have to drop the current table, so be careful that you
don't loose any important data. If unsure backup
your current table before loading backup_table.sav into the
database. When the "mysql" is fed with
backup_table.sav the table will be created and all values will be
inserted into the table.
echo "drop table $table" > temp
mysql -h$host -u$user -p$pass $database < temp
mysql -h$host -u$user -p$pass $database < backup_table.sav
Made by Rune Madsen - added/updated 1999-06-14
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
