Matthew (UK), I have two questions regarding this:
1. are you using the tick that is under the ~ sign on US keyboards, or the ' which is under the " quotes on US keyboards? I tried both and get an error executing the following query in mysql client gui screen GRANT ALL mysql.* TO USER 'albert' mysql client tells me I have an SQL error I tried the other ` (the one under the ~) and that did not work either. 2. I have tried to enter passwords for users including root, yet mysql does not take them in, even though they are listed in my.ini (in clear which is odd) When I use the password in conjunction with the user I get an error that says access denied with password YES or sometimes with password NO. Any clues? Thanks for the help Albert Atlanta ----- Original Message ----- From: "Matthew Smith" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, September 02, 2003 8:29 AM Subject: RE: Abt Mysqldump > Hi > > The only problem I get with mysqldump is that if I have used a reserved word > as a column name, then the create starement fails. > > (eg > > CREATE TABLE fred ( > KEY int(10) not null default '0' > ); > > will fail (but as produced by mysqldump) > > However, if you edit the file and put ` characters either side of the column > name (ie KEY above) then it then works. > > You can sort this in the first instance if you use the '--quote-names' or > '-Q' option to mysqldump > (OK, so I've just read the man page for the first time as well) > > > Regards > > Matthew > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: 02 September 2003 18:39 > To: [EMAIL PROTECTED] > Subject: Re: Abt Mysqldump > > > use > mysql database-name < backupfilename > I think , the backup file name should have .sql extension , like backup.sql > > "Hoeven, Maarten van der" wrote: > > > What are the errors? > > > > For example, is the error like unable to create the tables, because the > > tables still exist? See the dumpfile if tables are created (by default). > > If so, delete the tables first, and redump back the dumpfile. > > > > -----Original Message----- > > From: Uma Shankari T. [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, September 02, 2003 1:33 PM > > To: [EMAIL PROTECTED] > > Subject: Abt Mysqldump > > > > Hello, > > > > I have dumped the database contents as one txt file by using this > > command > > > > mysqldump databasename -uusername -ppasswd > textfilename. > > > > but while redumping back to mysql it is giving some errors in the > > textfile..is there any possibility to redump the contents without any > > error.. > > > > Regards, > > Uma > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > -------------------------------------------------------------- > > Zie ook/see also: http://www.knmi.nl/maildisclaimer.html > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > . > > -- > Vidhya CS > > > > . > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]