Re: restore from mysqldump file

2004-07-03 Thread Andrew Pattison
To do the restore: 1. Stop the MySQL server. On Windows NT/2000/XP you should use the command "net stop mysql" assuming you have installed MySQL as a service. On Unix/Linux, if you installed the init script, simply issue a command something like "/etc/rc.d/init.d/mysql stop" or "/etc/rc.d/init.d/m

Re: restore from mysqldump file

2004-07-02 Thread andy thomas
On Fri, 2 Jul 2004, Chuck Barnett wrote: > Hello, I have a huge problem that you guys may be able to help me with. > > I did a mysqldump all databases into a sql71.sql file. > > when I try and I get the following error when trying to restore > > ERROR 1050 at line 204528: Table 'columns_priv' al