Uploading MySQL Database?

[DOSMAN]

I'm a real n00b at MySQL and I'm just barely making my way by.


But I have managed to set up a database just how I want it on my local pc.

My question:
How do I upload it to my web host's server?

[Shorty]

Open a DOS window..

Navigate to your MySQL database folder (normally under Windows.. it's C:/mysql/bin

Type:

mysqldump --opt -uroot -p yourdatabasename > yourdataname.sql

Replace yourdatabasename by the name of your database :)

It will then prompt you for your root SQL password. Enter it and you will have an SQL dump.

Upload to your remote server. Then create the remote database name if you have the option. Some hosts provide you a database already created.

At the command line.. type

mysql -uusername -p createddatabasename < yourdatabasename.sql

Substitute username for your remote server database username, replace creatededdatabasename with the datbase name provided by your host.

That is a basic overview. If it makes no sense, drop me a PM as you don't want to go publishing database user/passes in public ;)

[a2jfreak]

I think Shorty covered it.

Good seeing you back on S-M DOSMAN. You stay away too much.

[DOSMAN]

mysqldump: Got error: 1045: Access denied for user: 'root@localhost' (Using password: YES) when trying to connect


What'd I screw up?

[DOSMAN]

Ok, I think that I forgot my local password. :shakehead

How do I reset it? I uninstalled/reinstalled but it didnt do anything.

[DOSMAN]

Oh never mind. Ha, i had NO password. No wonder none of my normal ones worked.

[Shorty]

Glad u got it :)

Need any help with the remote side.. let me know via PM :)

[DOSMAN]

Shorty is the greatest!!

My problem has been resolved