To talk on Icrontic, just register!

It only takes 30 seconds.

Have an account? Sign in:

Forgot?
DOSMAN
Old Timer
DOSMAN
246 Posts

Uploading MySQL Database?

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
Sniping teh enterpwise!
Shorty
9,543 Posts
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
__________________ I am a twit... follow me... @s8nftw
a2jfreak
madasiemanym
a2jfreak
3,351 Posts
I think Shorty covered it.

Good seeing you back on S-M DOSMAN. You stay away too much.
__________________
One thing kids like is to be tricked. For instance, I was going to take my little nephew to Disneyland, but instead I drove him to an old burned-out warehouse. "Oh, no," I said. "Disneyland burned down." He cried and cried, but I think that deep down, he thought it was a pretty good joke. I started to drive over to the real Disneyland, but it was getting pretty late.
Jack Handey
[folding_sig1]Child Search Ministries.
A Christian Charity for Missing Children.

Get Firefox!
DOSMAN
Old Timer
DOSMAN
246 Posts
Code:
mysqldump: Got error: 1045: Access denied for user: 'root@localhost' (Using password: YES) when trying to connect

What'd I screw up?
DOSMAN
Old Timer
DOSMAN
246 Posts
Ok, I think that I forgot my local password.

How do I reset it? I uninstalled/reinstalled but it didnt do anything.
DOSMAN
Old Timer
DOSMAN
246 Posts
Oh never mind. Ha, i had NO password. No wonder none of my normal ones worked.
Shorty
Sniping teh enterpwise!
Shorty
9,543 Posts
Glad u got it

Need any help with the remote side.. let me know via PM
DOSMAN
Old Timer
DOSMAN
246 Posts
Shorty is the greatest!!

My problem has been resolved
Go Back   Icrontic Forums > Tech: Software > Web & Digital Media
Jump to
This Thread Search this Thread
Search this Thread:

Advanced Search


Current time: 11:35pm (GMT)
Powered by vBulletin®
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Get Vanilla instead. Trust me.