Web Hosting Talk







View Full Version : Extracting file via mysql


saj
11-10-2003, 09:58 AM
hello all

how does one extract a file via mysql database?

i got this .sql file and i usually store .zip files and all in there..

but how can i actually retrive this file from the DB?

its just a backup i m trying to restore!

ive got several tables in the db including

-file_name
-file_size
-file_type


any help wud be appreicated

sri
11-10-2003, 10:42 AM
I am not sure I understand your question properly.

Are you trying to make a backup of your entire database or particular tables in your database?

or

Are you trying to restore certain tables or entire database from a .sql file?

VH-Robert
11-10-2003, 10:46 AM
He wants to extract a file from the MySQL Dump.

saj
11-10-2003, 10:48 AM
Hi

Yup thats it VH robert i would like to extract a file from mysqldump!! is this possible to do by any chance???

thanks

sri
11-10-2003, 10:54 AM
okay, I got you now. I do not know if what you are asking is possible. But you can always restore the tables (that have the data you want to extract) using the .sql file with you, go to your site and download the .zip file.

:rolleyes: