mySQL phpmyAdmin gurus - HELP!
 

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

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?

mysqldump -uUsername -p dbname > dbname.sql Export

mysql -uUsername -p dbname < dbname.sql Restore

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

didn't you try format c: ?

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?

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

exactly

Do you have Telnet/SSH access?

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....

I use this here on a local win SQL server

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

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

I can fix you in a week :winkwink:

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:

Life sucks, wife doesn't!

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

I love you man.