Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : Restoring forum issue

[Blueheaven]

I'm having problems extracting my home tar file and was wondering if I could get around it by

1. Creating the domain account
2. Importing the Database from phpmyadmin(saved export)
3. Uploading and Installing a fresh new Forum to its original form

Will this work

3a If so, Can I use a different forum version
or it has to be installed with the same version?

[gate2vn]

You should do the same version. and uploading, installing it first, exactly the same with old one, then restore DB.

but why dont you move all your forum to server?

[Blueheaven]

What if the sql file is too big for phpmyadmin, how could I go about importing it?

[adam]

You will need to login to SSH to do it then, how big is the file?

[Blueheaven]

Its about 15mb, what commands would I use in ssh to import?

would this work?
=====================

If your database backup resides on your home computer, you will first have to upload it via FTP to your website
Open your SSH/Telnet client and log into your website. The command line prompt you will see will vary by OS.
For most hosting companies, this will bring you into the FTP root folder.

Type in the following:

mysql -u dbusername -p databasename < /path/to/backupname.sql

You will be prompted for the database password. Enter it and the database will backup.

If your hosting company has you on a remote MySQL server, such as mysql.yourhost.com, you will need to add the servername to the command line. The servername will be the same as in your config.php. The command line will be:

mysql -h servername -u dbusername -p databasename < /path/to/backupname.sql
===============

[gate2vn]

You have a detail instruction there

mysql -u dbusername -p databasename < /path/to/backupname.sql

[zekoslav]

mysqldump -uusername -p table_name> file.sql
password:enter it
it will dump it to file.sql
move it to some dir when you can access it through http
ssh to new host, wget www.oldhost.com/path/to/sqlbackup/file.sql
mysql -uusername -p table_name< opcije.sql

done

make sure that you created database and user on new host, and gave privileges to new user

[Blueheaven]

mysql -u dbusername -p databasename < /path/to/backupname.sql
yep that option seemed to work for me, I wasnt using the < bracket but after I added it, the code worked.

I had to edit the username password and database name in forum config and then its seemed to work great

thankyou all for your help

[zekoslav]

Blueheaven and gate2vn
i belive you are wrong
syntax is
mysql -udbusername
not mysql -u dbusername

notice the space betwean -u and dbusername

[rasputinj]

Originally posted by zekoslav
Blueheaven and gate2vn
i belive you are wrong
syntax is
mysql -udbusername
not mysql -u dbusername

notice the space betwean -u and dbusername

I think you are wrong and BlueHeavan/gate2vn are right.

mysql -u Username -h localhost -p Password dbname < file_to_import_name



or you can use
user=Username --password=Password -- that is what I use.


If I wrong please let me know.

[rasputinj]

Originally posted by rasputinj
I think you are wrong and BlueHeavan/gate2vn are right.

mysql -u Username -h localhost -p Password dbname < file_to_import_name



or you can use
--user=Username --password=Password -- that is what I use.


If I wrong please let me know.

[Blueheaven]

i think both examples could be right, but the one I used is definetely right as I just restored another php script.