moving of database record

[uatt]

I am now decide to move my site from one host to another..
Just one question..
how I move information from one mysql to another mysql which is running by another webhosting company...

[seanf]

If you have Telnet access:

mysqldump -u username -ppassword database > yourfile.sql

Sean

[peanuts]

or with phpMyAdmin select make a dump of the database structure and data! also select send and you get your own little SQL file which you can use to build up the complete database.

Good luck

Peanuts

[seanf]

Beware of using phpMyAdmin on DBs over 7mb

Sean

[TheOriginalH]

What's the prob Sean?

[seanf]

Earlier versions screwed the data up. Plus you have to beware of PHP timeouts with any version

Sean

[TheOriginalH]

bugger. I've been using it a lot recently (v 2.1.0)

[uatt]

Thanks everybody..
I can only gain access mysql
so ...select make a dump
also select send ....
then how put it back to another mysql...

[seanf]

With Telnet use:

mysql -u username -p databasename < file.sql

With phpMyAdmin select your database and enter the SQL code into the textarea

Sean

[uatt]

seemingly very simple..
I'll try it and thanks....