Code Forums - View Single Post

DarkTwilkitri · 10-27-2003, 02:39 AM

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?

10-27-2003, 02:39 AM	#1 (permalink)
DarkTwilkitri Registered User Join Date: Feb 2003 Location: Australia Posts: 21	Methods of moving a database... 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?