exporting a mySQL database

[Anon]

I am relatively new to the world of php and mySQL.
I have built a Database using mySQL on my home PC. I now want to be able to put it onto the internet so that it works(isp = ONEandONE). I dont know how to do it.

Could somebody help me with this??

[[deleted]]

If you have shell access, you can use mysqldump to get your entire database in one large textfile that contains all the SQL queries needed to re-create your database on another server.

If you don't have shell access, see if you can connect to you ISP's database from your development server directly.

If that is also not possible, contact your ISP.

required reading:
http://www.mysql.com/doc/m/y/mysqldump.html

[Anon]

Use PHPMyADMIN.

Download it(http://phpmyadmin.sourceforge.net/), install it and change the correct variables (host is dbxx.oneandone.co.uk).

Upload it.

Then, install it and configure it locally (http://localhost/ and host is localhost).

Open it locally (so http://localhost/phpmyadmin) and dump all tables. Check 'Save as file'.

Open is from oneandone (www.yourdomainname.co.uk/phpmyadmin/) and insert the query by selecting the .sql file from the browse box and clicking submit. Your tables will appear.

If you need any more help, e-mail me on [e-mail].

View my sites at http://www.countrytraditionals.com - the finest Polish Pottery.

vincent wrote:

If you have shell access, you can use mysqldump to get your entire database in one large textfile that contains all the SQL queries needed to re-create your database on another server.

If you don't have shell access, see if you can connect to you ISP's database from your development server directly.

If that is also not possible, contact your ISP.

required reading:
http://www.mysql.com/doc/m/y/mysqldump.html