Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

How do I restore database with mysql client???


raatish

Recommended Posts

I am novice at osCommerce and I always mess things up. Recently I tried to uppload a contribution and messed everything up. I have succeeded in reinstating everything except that I can not restore the recent back-up of database. Its a bit too big (4,946,870 bytes). When I try to restore it, the browser eventually gives up and goes to Page cannot be shown.

 

Database Backup Manager suggests "If possible, use the mysql client."

 

How do I do that?

 

I would appreciate quick help as I can not afford to have my website down for long.

Link to comment
Share on other sites

I'm by no means a mySQL expert, but I think I might be able to point you in the right direction?

 

It sounds as if you need to log in to your domains control panel. For example for me that would be http://www.domainname.com/cpanel

 

Once logged in you have the option to manage your mySQL databases. From here there should be a link to phpmyadmin

 

Click that link and you should be able to import your backed up database using the import tab.

 

Hope that helps, like I say I'm just getting to grips with things myself.

 

Let us know how you get on, and if this helped/ or need any more help :thumbsup:

Link to comment
Share on other sites

The previous post is in the right direction. I am also expert but before doing this backup your database and it is usually a good idea to drop all the contents of a database before doing an import.

Backup before making changes. Backup before making changes! Backup before making changes!!

 

You did do a backup? eh?

Link to comment
Share on other sites

The previous post is in the right direction. I am also expert but before doing this backup your database and it is usually a good idea to drop all the contents of a database before doing an import.

 

It did not work. I have saved database on 5-6 differetn ocassions. I imported latest database (the one I want to restore) by "phpMyAdmin" and I got message that Lost connection to MySQL server during query".

 

Is there any other way to do this.

 

When you say "Backup before making changes." do you only mean back-up of database by Database Backup Manager or more?

Link to comment
Share on other sites

It did not work. I have saved database on 5-6 differetn ocassions. I imported latest database (the one I want to restore) by "phpMyAdmin" and I got message that Lost connection to MySQL server during query".

 

Is there any other way to do this.

 

When you say "Backup before making changes." do you only mean back-up of database by Database Backup Manager or more?

 

Divide the sql file.

Open your .sql file in a text editor and copy the text little by little and paste it in your mySQL

?,???`???,?? God must love stupid people, he made so many ??,???`???,?

Link to comment
Share on other sites

It did not work. I have saved database on 5-6 differetn ocassions. I imported latest database (the one I want to restore) by "phpMyAdmin" and I got message that Lost connection to MySQL server during query".

 

Is there any other way to do this.

 

When you say "Backup before making changes." do you only mean back-up of database by Database Backup Manager or more?

 

Backing up with Myphpadmin is also a good idea but I have never had trouble with the backups that osc creates. Perhaps the query is timing out.

 

Is your database large?

Backup before making changes. Backup before making changes! Backup before making changes!!

 

You did do a backup? eh?

Link to comment
Share on other sites

Backing up with Myphpadmin is also a good idea but I have never had trouble with the backups that osc creates. Perhaps the query is timing out.

 

Is your database large?

 

Yes, Database is large 4800 kB . I can restore older databases which are under 1000k Bs but not the ones which are above 3000 kBs.

 

About chopping the database into pieces and uploading it: Have someone tried it? Do I have to keep something in mind when I am making pieces of the database. Do I upload it the same way by using import function in Myphpadmin. Lets assume I make 4 pieces of the database, ?should alla go under the same name. Wouldn't they over write one another if they have the same name.

Link to comment
Share on other sites

Divide the sql file.

Open your .sql file in a text editor and copy the text little by little and paste it in your mySQL

 

Hey,

 

Thanks a lot. Your suggestions made my day. It worked. There were a lot of user tracking info in the database. I just kept some of them and deleted the rest. That broght down the size of DB from 4800 kB to 800 kB. And Bingo. Cheers.

 

Thanks for all the help everyone.

Link to comment
Share on other sites

  • 5 weeks later...

Hi,

 

I would like to check with you guys on backing up a database through OSC admin.

 

Does it backup all information like customers details, catalog etc etc?

 

Cos I'm new in this and would like to make sure that my backups are done properly in case of data lost one day and I do not wish to lose all my customers' data.

 

Appreciate your kind reply.

 

Thanks in advance!

Link to comment
Share on other sites

Hi,

 

I would like to check with you guys on backing up a database through OSC admin.

 

Does it backup all information like customers details, catalog etc etc?

 

Cos I'm new in this and would like to make sure that my backups are done properly in case of data lost one day and I do not wish to lose all my customers' data.

 

Appreciate your kind reply.

 

Thanks in advance!

 

All your customer data is in the database. It will be saved in your backup.

Backup before making changes. Backup before making changes! Backup before making changes!!

 

You did do a backup? eh?

Link to comment
Share on other sites

I just had the same issue - got a Page Cannot Be Displayed - LET IT GO - it is restoring in the background. I found this out after trying to restore again and again once I got that page display only to find out that after I let it sit there for awhile the database was fully restored.

 

I am novice at osCommerce and I always mess things up. Recently I tried to uppload a contribution and messed everything up. I have succeeded in reinstating everything except that I can not restore the recent back-up of database. Its a bit too big (4,946,870 bytes). When I try to restore it, the browser eventually gives up and goes to Page cannot be shown.

 

Database Backup Manager suggests "If possible, use the mysql client."

 

How do I do that?

 

I would appreciate quick help as I can not afford to have my website down for long.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...