mysqldump and LOAD DATA INFILE

ClyssaN

Hello,

Heres my situation:

I have a php script that executes the exec command to make a mysqldump of a given database to a file:

mysqldump -uroot -p12345 --add-drop-table -Q mydatabase --result-file=dumpfile.sql

To restore the database i use:

mysql -uroot -p12345 mydatabase < dumpfile.sql

This works very well because i want to make a full backup from my webpage and then restore it if necessary.

Now the problem is this, i had to move my site to a new server, and the new server runs php in safe mode, so i'm able to run the mysqldump but i'm not able to run the mysql < dumpfile because the "<" is not permited... dont know why...

Is there a way to use the LOAD DATA INFILE to import the file generated by mysqldump? The dumpfile.sql deletes and creates the tables

I tried the LOAD DATA INFILE but with no success, i have no experience with this command.

So to resume, is it possible to import a full database with the LOAD DATA FILE command from a mysqldump file, all done via webpage?

Thank in advance.

sneakyimp

this sounds to me like a permissions issue. When your PHP script runs mysqldump, the OS is probably creating a file that belongs to the user 'apache' or 'mysql' or something and then safemode is prohibiting you from accessing that file?

I'm not sure at all how to proceed. Are you getting an error? Perhaps you could post some code from the script that is running?

ClyssaN

Hi,

The tecnical support from my server provider told me that the php is running in safe mode, so the operator "<" or ">" cannot be execute, dont know why ...

I have permission to execute de mysqldump and mysql commands, so with mysqldump the problem is solved because the ">" is replaced with --result-file=

So instead of using:

mysqldump -uroot -p12345 --add-drop-table -Q mydatabase > dumpfile.sql

I use:

mysqldump -uroot -p12345 --add-drop-table -Q mydatabase --result-file=dumpfile.sql

The problem is to import the dumpfile created with mysqldump, since i cant use:

mysql -uroot -p12345 mydatabase < dumpfile.sql

I was told do take a look at the LOAD DATA FILE but until now i cannot figure it out how to import the dumpfile with the same result as:

mysql -uroot -p12345 mydatabase < dumpfile.sql

Any help would be very appreciated.

Thanks

sneakyimp

give this page a look:
http://dev.mysql.com/doc/refman/5.0/en/load-data.html

there are some examples there and it spells out the necessary syntax.

ClyssaN

I have checked that page, from what i tried, it seems i have to create another method of backing up my databases without mysqldump so i can user load data 🙁

thank for your help.