Can anyone answer ANY of these MySQL questions?!

[barry_does_it]

[I posted this early yesterday and just deleted it to bring it on top again (...nifty feature) since no one replied.]

1: My first question about MySQL: is the data (not the SQL/DDL table structure) stored in any file format (text based or binary) on the server by default?

2: I've read that you can backup your all your data and SQL-schema into a single text file using "MySQLdump". Can this single ".txt" file also handle large binary fields containig many BLOBs (i.e.: images, PDFs, etc.)?

3: What is the best and/or most common practice on how developers upload MySQL data to remote Web-Hosts/ISPs?

Thanks;
Barry

[tasistro]

1: My first question about MySQL: is the data (not the SQL/DDL table structure) stored in any file format (text based or binary) on the server by default?

Yes it is stored. The extension depends on the table type say ISAM or MyISAM or whatever. Some file formats are not OS independent. So a brute copy from one machine to another will NOT work.

2: I've read that you can backup your all your data and SQL-schema into a single text file using "MySQLdump". Can this single ".txt" file also handle large binary fields containig many BLOBs (i.e.: images, PDFs, etc.)?
Don't know, try it out. It has worked for me in all other field types.

3: What is the best and/or most common practice on how developers upload MySQL data to remote Web-Hosts/ISPs?

mysqldump to a file, move file from one place to another via ftp then login into mysql and

source %your dumpfile here%;

Saludos
Gerardo

[pnoeric]

barry_does_it - you've seen the mysql docs online, right? they're very detailed and may help elucidate some of these answers. -E

[barry_does_it]

Originally posted by tasistro
1: My first question about MySQL: is the data (not the SQL/DDL table structure) stored in any file format (text based or binary) on the server by default?

Yes it is stored. The extension depends on the table type say ISAM or MyISAM or whatever. Some file formats are not OS independent. So a brute copy from one machine to another will NOT work.

2: I've read that you can backup your all your data and SQL-schema into a single text file using "MySQLdump". Can this single ".txt" file also handle large binary fields containig many BLOBs (i.e.: images, PDFs, etc.)?
Don't know, try it out. It has worked for me in all other field types.

3: What is the best and/or most common practice on how developers upload MySQL data to remote Web-Hosts/ISPs?

mysqldump to a file, move file from one place to another via ftp then login into mysql and

source %your dumpfile here%;

Saludos
Gerardo

Muchas gracias Gerardo
B.