Since I am on Windows, I prefer to use a GUI tool like SQLyog (www.webyog.com)
Karam --- Adrian Cooper <[EMAIL PROTECTED]> wrote: > Hello, > > I need to restore a mySQL dump file but cannot find > the right syntax. > > I have root access and have used: > > mysql -u root -p account_databasename < backupname > > But I am getting: Access denied for user > '[EMAIL PROTECTED]' (Using password: > YES) > > I have also removed the root password and got: > Access denied for user > '[EMAIL PROTECTED]' (Using password: No) > > What is the correct syntax please? > > Also, can I create a new database and restore the > dump file to it or do I > need to use the same database name as before? > > Thank you very much indeed. > > Best regards. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > Yahoo! Mail Stay connected, organized, and protected. Take the tour: http://tour.mail.yahoo.com/mailtour.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]