Charitha,
Monday, July 15, 2002, 8:54:03 AM, you wrote:
C> Is there any way in mysql to restore the data back after flushing off
C> all the data already present using a single command.
C> I am having backup of the db and i want to restore the data back in the
C> database by flushing off all the data already present.
It depends on how did you backup of your database and what options did
you use. Did you use mysqldump or mysqlhotcopy or what?
F.e. if you made database backup with mysqldump you can do
mysql database_name < backup_file
Note: if you don't use --add-drop-table option of mysqldump and you
restore data in the same database (which contains old data), you will
get errors such as: 'Table 'table_name' already exists' or 'Duplicate
entry 'x' for key x'
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
