mySQL phpmyAdmin gurus - HELP!

[Amputate Your Head]

if there's anyone that knows this shit.... I'm exporting my table data from an active db to text files and importing them into a new db, but when I try to import, the fucking delimiters are wrong or something and the data is getting scrambled into the wrong fields... anyone that can help..... please do.... ;-)

ICQ: 128198800

[Amputate Your Head]

better yet, is there any way to do the whole fuckin' db at once, or does it hafta be done one table at a time?

[Barry Porn]

mysqldump -uUsername -p dbname > dbname.sql Export

mysql -uUsername -p dbname < dbname.sql Restore

Originally posted by Amputate Your Head
better yet, is there any way to do the whole fuckin' db at once, or does it hafta be done one table at a time?

[Amputate Your Head]

as good as that looks, can you elaborate on it somewhat Barry?

[mika]

didn't you try format c: ?

[Barry Porn]

You need Telnet/SSH access to run those commands.

That will backup the database in question, and restore it exactly as is.

Or if you have 'Webmin' you can easily dump your database from there as well and restore it.

What are you trying to do?

Migrating your data from one server to the other?

[Dopy]

What are you using to export to flat files and where are the flat file records going to

[Amputate Your Head]

Originally posted by Barry Porn
Migrating your data from one server to the other?

exactly

[Barry Porn]

Do you have Telnet/SSH access?

Originally posted by Amputate Your Head

exactly

[Amputate Your Head]

Originally posted by Dopy
What are you using to export to flat files and where are the flat file records going to

Was trying to use that wretched phpmyAdmin and shoot 'em into csv delimited text files.... some worked fine while others just trash the damn tables....

[Dopy]

I use this here on a local win SQL server

http://www.gossamer-threads.com/scri...lman/index.htm

[Amputate Your Head]

Originally posted by Barry Porn
Do you have Telnet/SSH access?

I do on one server but not on the other....

[Ludedude]

I can fix you in a week

[Amputate Your Head]

I got Mascon, which works from one db to another here, but not from here to there.... fucking aggravating shit.

fuck it... I'm formatting c:

[mika]

Life sucks, wife doesn't!

[RK]

AMP, msg me on ICQ, I'll be happy to help you.

[Amputate Your Head]

Originally posted by RK
AMP, msg me on ICQ, I'll be happy to help you.

I love you man.