exporting db

scuba

Hi,

I'm trying to export a mysql DB. Is there any really good method of doing this? any help would be great.

Thanks,
Steve

Anon

Well, I suppose it depends what you want to export it to....

But check out the mysqldump command. this should help.

scuba

I was hoping to export it to a txt file, comma delimited, which may be imported into another mysql or oracle database.

I'm checking into mysqldump now but having some troubles...thanks for your input : )

Steve

Anon

Normally, the mysql command will spit out a file consisting of a "CREATE TABLE" statement which recreates your tables, and then a bunch of INSERT statements that fill the tables. the --tab option of mysqldump allows you to create 2 files: 1 with the table creation, and 1 with raw data.

so if you tried:

myslqdump --tab=(dataDirectory) --fields-terminated-by="," (databaseName)

you will get 2 files inside of the dataDir, one .sql file which is the table creation, and one .txt file which is the raw data, comma delimitted.

does this help?

scuba

include("dataincludes/connect.inc");

$sql_dump = "myslqdump --tab=(http://mydir) --fields-terminated-by=',' (mydatabase)";

$sql_dump_result = exec($sql_dump);

echo "
\n sql_dump_result is " . $sql_dump_result;

return $sql_dump;
}
?>

I tried this but what returns on screen is:
sql_dump_result is myslqdump --tab=(http://mydir) --fields-terminated-by=',' (mydatabase)

plus i don't see any files created.

Anon

sorry if i wasn't clear before....mysqldump isn't a php function. it's a command line function.

Anon

oh wait, i see what you're doing. well, i don't know what to tell you then...have you looked at MySQL docs about mysqldump???

Anon

in the tab option, are you giving it a URL? it looks that way (http://). you should be giving it a path name.

manny

i wanted to transfer hosts. how do i transfer my database? im using phpmyadmin now. what's the best way to do it without losing information?

thanks

crislewis

If you are using phpmyadmin then simply use the dump option on the database page. This will create a file for you with all the sql you need to recreate the tables AND the data (using inserts). Works for me every time.

Cheers,

Cris

crislewis

Steve,

You only need to perservere with this if you want to automate a regular export function. If you simply want to move a replicate a database and/or table for development purposes and irregularly, then use the dump feature in phpmyadmin. Its a godssend.

Cris