Originally Posted by mlseim
So you have a file on your PC with the .sql file extension.
That file was created by your PHP script, it spit-out the .sql content,
and you saved it on your PC. Now you want to go in reverse ... you
want to take that .sql file and restore the database ... is that correct?
I'm just trying to follow what you mean by "restore db table".
We might both be thinking of two different things.
If what I'm thinking is correct, you need to have access to "phpMyAdmin".
This is usually done using your webhost (website) control panel. They have
a thing in the control panel called "phpMyAdmin" where you can access
all of your mysql databases, view them, edit them, add/delete. You can
also present it with an .sql file ... like the one you saved as a backup.
It will execute that .sql file and perform the query instructions to restore
Yes, that is right, the thing is I have developed a huge php application
in my institution and huge amount of data is expected to be uploaded (restoring/import to remote server) and downloaded (backup/export from remote server).
I am very familiar with phpMyadmin and that my web host company provides that platform. The problem I found with that is, I have a given a limitation of importing only 10.2Mb of data from phpMyadmin.
At this moment I have only 55Mb of data for the whole database and I frequently upload and download one table of size 9Mb though I zip it and get 1-2 Mb, but am sure it come a time where I will be required to import say 100Mb.
Therefore If I have the script in the application it will be easier to do so. And that is why I asking for script of restore table back to the database, cause I have the script for taking backup from database. This is a link to the login page of that application: http://tais.teku.ac.tz