mysql -u user_name -p reporter < dumpfile Leaving a space between -u (=user) and the user_name should not be a problem it is if you supply a password on the commandline -p'your_password' but -u user_name
B. > -----Oorspronkelijk bericht----- > Van: Mikael Fridh [mailto:[EMAIL PROTECTED] > Verzonden: zondag 23 november 2003 13:48 > Aan: [EMAIL PROTECTED]; Nilesh Avalani > Onderwerp: Re: restoring mysqldump ??? > > > > but when i try to run : > > % mysql -u root reporter < reporter-dump-Sat.sql > > mysql -uroot -p reporter < dumpfile > > > it says : > > ERROR 1044: Access denied for user: '@localhost' to > > database 'reporter'. > > think it's because of that extra space between the '-u' and > 'root' you also need the -p parameter so you can enter your > root password. > > Mike > > -- > 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]