Methods of moving a database...

[DarkTwilkitri]

Right, I've got a MySQL database on my local computer.
I want to move it to an online computer.

But, the host has set it up that not only can no-one access the MySQL directories, but also the only one who can even connect to MySQL is the computer itself.

I was thinking that I should write a PHP script to go through the database and generate a script, which recreates the database when ran. NOTE: I AM NOT ASKING FOR HELP WRITING SAID SCRIPT. I know that someone would take me to mean that :/ I've written out database recreation scripts by hand before, I know how to make them.

What I'm asking is, are there any alternate methods of accomplishing this?

[sde]

www.phpmyadmin.net/

if you haven't checked that out, you should. it's php scripts which manage your mysql database.

load it on your local computer, then configure the config file.

you can then backup your table structure + data into a single file.

then, just upload the same scripts to your web host after configuring the config file with the web host info, and you can load up a database with the backup file you made on your local computer.

this is probably the easiest way to accomplish what you are trying to do.

you can backup your mysql database from the command line on your local computer, but you would probably have to use the scripts i mentioned above anyway to get the backup to the web host.

let me know if you have any trouble or questions.

[joe_bruin]

look at the program 'mysqldump'. it should do everything you need.

[sde]

that would only work if he has shell access right?

[joe_bruin]

giving you the ability to execute php scripts but no shell access is like giving you a crowbar but not the keys to the front door.

[sde]

Originally posted by joe_bruin
giving you the ability to execute php scripts but no shell access is like giving you a crowbar but not the keys to the front door.

nice analogy .. but a lot of web hosts work that way.

[idx]

Originally posted by sde
that would only work if he has shell access right?

old thread, but wtf.

He could use mysqldump on his local system, then take the text file and load it into his host through whatever method they've setup. (probably phpmyadmin)

[sde]

if his host allows mysql traffic from external servers .. i think most hosting companies secure that pretty tight.

[idx]

Originally posted by sde
if his host allows mysql traffic from external servers .. i think most hosting companies secure that pretty tight.

That's not what I meant. The hosting co has to have given him some DB admin util. Just use that with the output from his local mysqldump.

-r