hi , I am trying to restore my .sql GZ file on ipowerweb server but it does not work ..can you tell me how to retore file on host server please.
There is a section on restoring in the script instructions..
Here it is..
# Firstly you will need to uncompress the backup file.
# gunzip file.gz (or bunzip2 file.bz2)
# Next you will need to use the mysql client to restore the DB from the
# sql file.
# mysql --user=username --pass=password --host=dbserver database < /path/file.sql
# mysql --user=username --pass=password --host=dbserver -e "source /path/file.sql" database
# NOTE: Make sure you use "<" and not ">" in the above command because
# you are piping the file.sql to mysql and not the other way around.
Hope that helps..
Thanks I will try this.
You can also use a program called "phpmyadmin" (http://www.phpmyadmin.net) which is often times install by server admins already.
You can paste the .sql file into the "SQL" box and hit go.
I find phpmyadmin easier to use than command line. IMHO
P.S. entries in the sql file should look like this:
"-- Table structure for table `address_book`
DROP TABLE IF EXISTS `address_book`;
CREATE TABLE `address_book` (
When in doubt ask your isp or guru.
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.