export - import MySql dbase ? - GoFuckYourself.com

PantieZ · 10-29-2004, 10:08 AM

how can i do this ?

Babaganoosh · 10-29-2004, 10:10 AM

mysqldump

Google it, it's easy.

Varius · 10-29-2004, 10:11 AM

Quote:

Originally posted by PantieZ
how can i do this ?

Easiest method is to use mysqldump to export it. Then you can sue that file for import....example:

mysqldump -h -u -p (put your values) db_name > file.sql

mysql -h -u -p db_name < file.sql

SinSational · 10-29-2004, 10:11 AM

how many records?
if is is small, you can just do a dump with phpMyAdmin.

if big then easy way is just to make a php page that writes to a text file and then you can insert from that text in to the new table.

backup/restore php page.

Babaganoosh · 10-29-2004, 10:12 AM

Quote:

Originally posted by SinSational
how many records?
if is is small, you can just do a dump with phpMyAdmin.

if big then easy way is just to make a php page that writes to a text file and then you can insert from that text in to the new table.

backup/restore php page.

That's a lot of unnecessary work. mysqldump is the correct way to do it.

PantieZ · 10-29-2004, 10:26 AM

Quote:

Originally posted by Armed & Hammered
That's a lot of unnecessary work. mysqldump is the correct way to do it.

thanks a lot !!

10-29-2004, 10:08 AM	#1
PantieZ Confirmed User Join Date: Jan 2001 Location: Panty Land Posts: 1,441	export - import MySql dbase ? how can i do this ?

10-29-2004, 10:10 AM	#2
Babaganoosh ♥♥♥ Likes Hugs ♥♥♥ Industry Role: Join Date: Nov 2001 Location: /home Posts: 15,841	mysqldump Google it, it's easy. __________________ I like pie.

10-29-2004, 10:11 AM	#4
SinSational Confirmed User Join Date: Oct 2004 Location: Boston, MA Posts: 1,723	how many records? if is is small, you can just do a dump with phpMyAdmin. if big then easy way is just to make a php page that writes to a text file and then you can insert from that text in to the new table. backup/restore php page. __________________ ICQ# 273099174 - monthly specials - 2 Month Free Credit on All Plans - 100% Referrals - chris@ for details Virtual from $14.95/month, Dedicated from $149.95/month Dual-Core Xeon > 1000GB @ $149.95 \| 1500GB @ $169.95 \| 10Mbps @ $269.95