Thread

Hi there,

I’m trying to export my EE database using PuTTY, but it doesn’t seem to be working.

I used this command:

mysqldump -u *username* -p unifusion_db > unifusion_db.sql

I didn’t add a semicolon at the end because all tutorials I found didn’t use one, but nothing happpened when I hit enter, I just got an arrow.

So I entered the same command with a semicolon at the end and I got this error:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘mysql dump -u *username* -p unifusion_db > unifusion_db.sql

mysqldump -u *username* -p unifu’ at line 1

I’ve attached a screenshot of what I did, and the error that came up. I’m not sure what I’m doing wrong here, any suggestions?

If you are not providing a password in your command you’ll have to enter it manually on the console. Try this:

mysqldump –-user foo –-password=suprsikrit my_db > my_db.sql

Didn’t work. I tried a couple variations but those didn’t work either. See attached for a transcript of what I did.

I’m also not able to delete my forum entries. Haven’t been able to for some time now.

I figured it out. I wasn’t supposed to log-in to MySQL before giving the dump command. I was just supposed to do it in the regular command line.