MySQL Forums
Forum List  »  Newbie

Re: Migrating MySql from Debian to Windows
Posted by: Barry Galbraith
Date: June 19, 2014 09:45PM

>Anyone know how I can take a look inside to see what the mybackup.sql file contains?

It's only a plain text file. You can use any text viewer to open it, or
shell> more /path_to/mybackup.sql

If you don't use a user and password, it will only contain the error message that you couldn't connect, unless anonymous access is allowed, and you'll get the test database.

> I kept getting a "Got Error:1045 Access denied for user "root@'localhost'".

Can you open the mysql command line client with mysql -uroot -p ?
If so, then should be able to invoke mysqldump with the same user/password.
If not then you'll either need to find root's password, or reset root's password.

Good luck,
Barry.

Options: ReplyQuote


Subject
Written By
Posted
Re: Migrating MySql from Debian to Windows
June 19, 2014 09:45PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.