How to import sql db to new hosting?

[dynn]

I want to shift my current phpld directory to new host.My problem how to import the current sql db to the new host.

Pls help...thanks

[Boby]

If you are running phpLD 3 you have an backup feature, but for all versions you can use PHPMyAdmin. Go to "export", do the backup and then "import" (via PHPMyAdmin) to the new host.

Check these settings on the "export" page and select all tables in PHPMyAdmin:
Structure
Add DROP TABLE
Add IF NOT EXISTS
Add AUTO_INCREMENT value
Enclose table and field names with backquotes
Data
Complete inserts
If your DB is huge, over 2MB, use Bigdump (http://www.ozerov.de/bigdump.php) for importing.

Boby

[arindra]

bigdump sounds nice ... never knew it before

[anon]

haha 'big dump'


hahahaha :D

[gmschmitz]

I'm trying to take some links from one of my directories to another. Same hosting company, I'm just trying to export and then import to the other database and I can't seem to get it to work. I'm using PHPMyAdmin but know know to much about it. When I try to import it doesn't put the links in correctly. Any help on how to export the links (what file type) and how to import them would br great.

Thanks