mySQL phpmyAdmin gurus - HELP! - GoFuckYourself.com

Amputate Your Head · 02-03-2002, 03:48 PM

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 · 02-03-2002, 03:49 PM

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 · 02-03-2002, 03:51 PM

mysqldump -uUsername -p dbname > dbname.sql Export

mysql -uUsername -p dbname < dbname.sql Restore

Quote:

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 · 02-03-2002, 04:18 PM

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

mika · 02-03-2002, 04:20 PM

didn't you try format c: ?

Barry Porn · 02-03-2002, 04:21 PM

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 · 02-03-2002, 04:28 PM

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

Amputate Your Head · 02-03-2002, 04:28 PM

Quote:

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

exactly

Barry Porn · 02-03-2002, 04:28 PM

Do you have Telnet/SSH access?

Quote:

Originally posted by Amputate Your Head

exactly

Amputate Your Head · 02-03-2002, 04:29 PM

Quote:

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 · 02-03-2002, 04:34 PM

I use this here on a local win SQL server

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

Amputate Your Head · 02-03-2002, 05:11 PM

Quote:

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

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

Ludedude · 02-03-2002, 06:47 PM

I can fix you in a week

Amputate Your Head · 02-03-2002, 06:54 PM

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 · 02-03-2002, 06:57 PM

Life sucks, wife doesn't!

RK · 02-03-2002, 07:46 PM

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

Amputate Your Head · 02-03-2002, 08:40 PM

Quote:

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

I love you man.

02-03-2002, 03:48 PM	#1
Amputate Your Head There can be only one Industry Role: Join Date: Aug 2001 Location: Somewhere else Posts: 39,075	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

02-03-2002, 07:46 PM	#16
RK Confirmed User Join Date: Aug 2001 Location: In a Bunker Posts: 868	AMP, msg me on ICQ, I'll be happy to help you. __________________ Does anyone look down here?

02-03-2002, 03:49 PM	#2
Amputate Your Head There can be only one Industry Role: Join Date: Aug 2001 Location: Somewhere else Posts: 39,075	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?

02-03-2002, 04:18 PM	#4
Amputate Your Head There can be only one Industry Role: Join Date: Aug 2001 Location: Somewhere else Posts: 39,075	as good as that looks, can you elaborate on it somewhat Barry?

02-03-2002, 04:20 PM	#5
mika Confirmed User Join Date: Sep 2001 Location: Finland Posts: 1,561	didn't you try format c: ?

02-03-2002, 04:21 PM	#6
Barry Porn Confirmed User Join Date: Oct 2001 Location: New Jersey Posts: 257	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?

02-03-2002, 04:28 PM	#7
Dopy Confirmed User Join Date: Feb 2001 Location: Puerto Del Carmen, Lanzarote, Canary Islands Posts: 1,572	What are you using to export to flat files and where are the flat file records going to

02-03-2002, 04:34 PM	#11
Dopy Confirmed User Join Date: Feb 2001 Location: Puerto Del Carmen, Lanzarote, Canary Islands Posts: 1,572	I use this here on a local win SQL server http://www.gossamer-threads.com/scri...lman/index.htm

02-03-2002, 06:47 PM	#13
Ludedude Suck it! Industry Role: Join Date: Jun 2001 Location: Who wants to know? Posts: 4,432	I can fix you in a week

02-03-2002, 06:54 PM	#14
Amputate Your Head There can be only one Industry Role: Join Date: Aug 2001 Location: Somewhere else Posts: 39,075	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:

02-03-2002, 06:57 PM	#15
mika Confirmed User Join Date: Sep 2001 Location: Finland Posts: 1,561	Life sucks, wife doesn't!