Hi, I would really appriciate if anybody can guide me about the backup and restore mysql database.
I have installed MySql server5.0.42 on windows xp sp3. I know how to create database, tables and inserting rows through from command prompt only.
i have created a db named 'search' having 3 tables. I tried to make backup using following command
mysql> mysqldump search > backupsearch.sql
where i am getting Error 1064 you have an error in your SQL syntax; check the mannual that corresponds to your MySql server version for the right syntax to use near 'mysqldump search > backupsearch.sql'
Can anybody give me the exact way to backup and restore mysql db.
With Kind Regards
I have installed MySql server5.0.42 on windows xp sp3. I know how to create database, tables and inserting rows through from command prompt only.
i have created a db named 'search' having 3 tables. I tried to make backup using following command
mysql> mysqldump search > backupsearch.sql
where i am getting Error 1064 you have an error in your SQL syntax; check the mannual that corresponds to your MySql server version for the right syntax to use near 'mysqldump search > backupsearch.sql'
Can anybody give me the exact way to backup and restore mysql db.
With Kind Regards