Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
06-26-2005, 10:09 AM #1
- Join Date
- Apr 2005
- Lahore, Pakistan
- Thanked 0 Times in 0 Posts
how to upload mysql database file to any server
How to upload MYSQL database file(*.sql) to a server . Because my hosting provider does not have a powerful control panel. I just know the username, password and ip address of the server on which i can upload database file.
06-26-2005, 03:50 PM #2
- Join Date
- Sep 2002
- Saskatoon, Saskatchewan
- Thanked 2,662 Times in 2,631 Posts
The easiest way would be to create an upload directory, read the file contents and follow the instructions.
.sql files contain a query on a single line of instruction. file() is a good option to use if you create a temporary file for it. Otherwise, you would need to create an array out of your temporary data by exploding it on each newline.
From that point, running a query would be a cinch. The trickier part will be to impliment some sort of security and control to it.
Will this be enough to help, or would you like a quick example?
Last edited by Fou-Lu; 06-26-2005 at 03:56 PM.