PDA

View Full Version : Problems with Restoration DB

AdminSatfree
01-18-2004, 10:05 PM
I have problems with Restoration DB.
The file size 18 mb.
Should use what commands SSH?
Please help me.


Kind regards
Alex.
Viper007Bond
01-18-2004, 10:58 PM
So did you export the database to a text file (it'll be name ___.sql actually) or did you export via SSL (can you do that?). If you did the backup via SSL, I have no clue, I don't back up my databases that way.

If you have a text document backup, just restore it with phpMyAdmin - http://yourdomain.com/phpmyadmin/ and then click the SQL tab.
AdminSatfree
01-19-2004, 07:29 AM
Originally posted by Viper007Bond
So did you export the database to a text file (it'll be name ___.sql actually) or did you export via SSL (can you do that?). If you did the backup via SSL, I have no clue, I don't back up my databases that way.

If you have a text document backup, just restore it with phpMyAdmin - http://yourdomain.com/phpmyadmin/ and then click the SQL tab.

SQL tab.
The maximal file size for recording in this function 2mb.
I should restore BD the size 18 mb.
I do not understand as it to make.
To edit php.ini?
AdminSatfree
01-19-2004, 07:34 AM
Originally posted by Viper007Bond
So did you export the database to a text file (it'll be name ___.sql actually) or did you export via SSL (can you do that?). If you did the backup via SSL, I have no clue, I don't back up my databases that way.

If you have a text document backup, just restore it with phpMyAdmin - http://yourdomain.com/phpmyadmin/ and then click the SQL tab.


Restoration from gzip gives out mistakes after recording.
Different parts bd have the size 8mb post users and names of users.
paolorulez
01-19-2004, 08:27 AM
restore database with ssh

upload files.sql in your directory

open putty or secure CRT

send

mysql -uuser -ppassword databasename < /home/yourname/public_html/TEST/backup.sql


regards
Viper007Bond
01-19-2004, 08:30 AM
Originally posted by AdminSatfree
SQL tab.
The maximal file size for recording in this function 2mb.
I should restore BD the size 18 mb.
I do not understand as it to make.
To edit php.ini?
For importing, there is not maximum file size last time I did it, but it will time out if the file is too big.

If you really can't get it to upload, then FTP it to your server and send in a TT asking that they insert that backup.

Or maybe you can do the SSL thing - never messed with databases via SSL, hell, never messed with SSL at all...