Restoring backup

[Guest]

I have a live store wich have been online for aprox 3 years.

 

Becouse I want to do a couple major changes to my site, I have descided to go for a "development store".

I have made a development store, and uploaded most from the old site to the new via ftp. However when I try to restore the database, nothing happens. The .sql file is aprox 13mb. I have also tried to do it via mysql but Im not having any succsess... Anybody know what the problem is?

[AlanR]

You're trying to use the osC restore tool?

 

Use phpMyAdmin but compress the file before you attempt the import. sql files are ideal for compression with lots of repetitive text. Depending on the method of compression you'll reduce the file size by up to 90% or even less (bzip2). phpMyAdmin understands and handles compressed files.

 

Also, if you have your own copy of phpMyAdmin on your server you can define server based import and export directories. This lets you upload the file to the server via ftp (which may be slow) then import to the db from the server based file.

[Guest]

You're trying to use the osC restore tool?

 

Use phpMyAdmin but compress the file before you attempt the import. sql files are ideal for compression with lots of repetitive text. Depending on the method of compression you'll reduce the file size by up to 90% or even less (bzip2). phpMyAdmin understands and handles compressed files.

 

Also, if you have your own copy of phpMyAdmin on your server you can define server based import and export directories. This lets you upload the file to the server via ftp (which may be slow) then import to the db from the server based file.

 

 

Thank you for your help.

What is "bzip"?

 

I have tried the osC restore tool,

[AlanR]

Thank you for your help.

What is "bzip"?

 

I have tried the osC restore tool,

You'll have much better luck with phpMyAdmin.

 

bzip is just a somewhat newer form of compression used by *nix systems. It creates smaller files than gzip by about 15%. phpMyAdmin understands it when files are imported.

 

Your 13Mb file may be less than 1Mb once compressed.

[Guest]

You'll have much better luck with phpMyAdmin.

 

bzip is just a somewhat newer form of compression used by *nix systems. It creates smaller files than gzip by about 15%. phpMyAdmin understands it when files are imported.

 

Your 13Mb file may be less than 1Mb once compressed.

 

thank you again, highly apriciated!

Is bzip something I download? If so, where?

 

Thank you again.