how to download mysql database contents?
Posted: Sun Jul 28, 2002 4:43 am
Hi,
I may change hosting company and I wonder what's the best way to retrieve my database contents.
I could somehow dump each record from each table to an HTML page (some fields are blobs) and read the url from my pc to rebuilt the database locally and check it.
Then upload it again, though I am unsure how, except as php files holding sql inserts.
Or read the URLs directly from my new host.
Do such download/upload example scripts exist?
Any better idea than using HTML pages to dump it and retreive it all?
Any security, data formatting, etc. isuue I should be careful about?
Thanks for your insight.
I may change hosting company and I wonder what's the best way to retrieve my database contents.
I could somehow dump each record from each table to an HTML page (some fields are blobs) and read the url from my pc to rebuilt the database locally and check it.
Then upload it again, though I am unsure how, except as php files holding sql inserts.
Or read the URLs directly from my new host.
Do such download/upload example scripts exist?
Any better idea than using HTML pages to dump it and retreive it all?
Any security, data formatting, etc. isuue I should be careful about?
Thanks for your insight.