How do I restore database with mysql client???

[raatish]

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.

[davidell]

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:

[ddp]

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.

[raatish]

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?

[shaytaan]

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

[ddp]

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?

[raatish]

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.

[raatish]

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.

[pingz]

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!

[ddp]

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.

[swardwll]

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.