database restore

[Guest]

hello again.

how can i restore my database. beucase i just reinstalled the package but before i remove the previous store i backup the database but every time i do the restore process there is no change

[noob]

what do u use for restoring the db

[Guest]

depends on how big your db is, as well as how fast your connection to your ISP is. restoring it via phpmyadmin does not always work well.

 

also depends on how you backed it up. restoring via the osCommerce admin utility doesn't always work for me, so I try to rely on the standard MySQL tools to do it.

 

The fastest way, if you have a hosting account that allows shell access, is to upload the .sql file (unzip it if it's zipped) and execute the command:

mysql --user=USERNAME --password=PASSWORD DATABASE_NAME < BACKUP.SQL

.

 

Notes:

- If you don't enter the password, just put in --password or -p instead, then it will prompt you for the password.

- replace USERNAME PASSWORD DATABASE_NAME and BACKUP.SQL with the appropriate values for your server

 

If you don't have a shell account, then you can either:

1) chunk up the .sql data into multiple files, and upload those files via phpmyadmin

2) ask your hosting provider to do it

3) use a "fake" shell like cgishell or phpshell (I don't think most hosts like you to do this for security reasons)

 

 

-jared