"John Doneker" <[EMAIL PROTECTED]> wrote on 10/11/2005 04:43:40 PM:
> Hi, I am trying to restore from an .sql file created by mysqldump. > To restore I am using mysqldump as well. > > I deleted all of the rows in a table. > When I restore it is still empty. > > I noticed on my screen that the dump does inserts but the restore does not. > I am using the -c option. > > Can someone please help? > > Thanks you all. > Wayne. > > > J. Wayne Doneker > BAE Systems > York Pa. > 717 225 8109 > Email: [EMAIL PROTECTED] > > mysqldump only creates a sql script of a database. It does not replay that script into a database. http://dev.mysql.com/doc/mysql/en/mysqldump.html The best tool for that would be the command line interface (CLI) otherwise known as mysql.exe. You can either redirect your script to play into the executable with a < or once you start it up you can replay your script with the "source" command (the shortcut for "source" is a period) http://dev.mysql.com/doc/mysql/en/mysql.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine
