Database Restore

[Guest]

I have recently got myself a dedicated server.

On this dedicated server there is Ensim, with power tools.

I have installed Os Commerce, everything works a threat...

Until I try to backup my old database..

 

When I upload the database to the backup folder via ftp, and try to restore it I get a blank page. Nothing happens. This happens innstantly.

 

When I use the upload/restore via oscommerce the file uploads and I get the following error:

 

Warning: set_time_limit(): Cannot set time limit in safe mode in /home/virtual/site1/fst/var/www/html/shop/admin/includes/functions/general.php on line 733

 

Warning: Cannot modify header information - headers already sent by (output started at /home/virtual/site1/fst/var/www/html/shop/admin/includes/functions/general.php:733) in /home/virtual/site1/fst/var/www/html/shop/admin/includes/functions/general.php on line 18

[Guest]

you should probably use phpmyadmin to import the file, the bottom warning is most likely because of the database being empty

[Guest]

you should probably use phpmyadmin to import the file, the bottom warning is most likely because of the database being empty

<{POST_SNAPBACK}>

 

I have never done that before, how is that proceeded?

[boxtel]

I have never done that before, how is that proceeded?

<{POST_SNAPBACK}>

 

 

if you have a dedicated server, get some dedicated mysql tooling like mysqlfront or something like that. Then you can mess with your databases to your hearts content.

[Guest]

ask your host how you can access phpmyadmin, if you have a cpanel look for where it says mysql databases, then scroll to the bottom after clicking on the icon and you will find a link to phpmyadmin.

you need to search the internet for a tutorial on phpmyadmin, makes it easy to learn how to use it.

mysql front requires you to be able to grant different rights to the databases from the 'root' prompt.

if you dont know how to use the sql command lines, you will need to learn, else you can wipe out things in a hurry.

[Guest]

ask your host how you can access phpmyadmin, if you have a cpanel look for where it says mysql databases, then scroll to the bottom after clicking on the icon and you will find a link to phpmyadmin.

you need to search the internet for a tutorial on phpmyadmin, makes it easy to learn how to use it.

mysql front requires you to be able to grant different rights to the databases from the 'root' prompt. 

if you dont know how to use the sql command lines, you will need to learn, else you can wipe out things in a hurry.

<{POST_SNAPBACK}>

 

Hello.

I have used phpmyadmin before, but never restored a shop database using it.

[Adima]

You can also use phpMyAdmin, but you need a bit of SQL knowledge.

 

phpMyAdmin is a very powerful tool, do not try to learn about it on a production server. Set up a local host on your computer instead.

 

If you need to learn SQL go to http://www.w3schools.com/sql/default.asp. It's easy and FREE!

[Guest]

To backup your database in to (db_xxxx-yyyymmddhhmmss.sql) format go to osCDox's Guide

 

xxxx = your database name

yyyymmddhhmmss = Year, Month and so on.....

 

Look for this section (near the bottom of the page).

Create the dir /catalog/admin/backups and set the permissions to 777

 

Than you can use the osCommerce's Administration|Tools|Database Backup to complete the backup.

 

Also look at the rest of the page if you are not familiar with setting file permissions.

<{POST_SNAPBACK}>

 

 

Thanks for all the help.

But I allready have a backup from my old site/server.

I just cannot get it into my new shop on the new server.

I realy need my old customer info and almost 2500 products in my new shop.

I have never encounted a problem like this before. And I have moved the shop 2-3 times before..

 

This is starting to get frustration...

 

Thanks for all help

[Geotex]

are you using exactly the same cart, or one that has modifications including database mods?

[Guest]

what kind of modifications do you mean?

Its ms 2.2

[Geotex]

what kind of modifications do you mean?

Its ms 2.2

<{POST_SNAPBACK}>

 

If you have a heavily modified version, the data base may not be compatible with the one you are trying to upload. If extra fields have been added, your back up will not know about them, and either place data in the wrong field, or, if you have drop table commands in the back up, will just replace the tables completely, causing lots of errors.

 

for example: If the new cart has something like BTS templates installed, where the old one did not, transferring data can become very complicated.

[Guest]

I understand.

I did a complete backup with files and everything so I upload everything on the new server.

 

There is no way to just import customer data, or products-data?

[Geotex]

If you uploaded all your files, including your copy of the oscommerce cart, then what I understand is that you have exactly the same version and modifications that you had on the old site.

 

If this is correct, a trick that sometimes works is to sign into your phpMyAdmin. Then, dump all the tables (not your database, just the tables). Then, when you do your restore, you will create new tables that exactly duplicate the ones in your prior cart.

 

hth.

[Guest]

ok, now I realy need help have used most of this day to tweaking, changing and trying out.. I just cant do it :(

 

I need away to get my backup file from my old server/site, on my new site... wish it could manage to do it soon..

 

Is there a way I can just take out the customer and product information, order information and inserting it to my site or something?

[Adima]

Thanks for all the help.

But I allready have a backup from my old site/server.

I just cannot get it into my new shop on the new server.

I realy need my old customer info and almost 2500 products in my new shop.

I have never encounted a problem like this before. And I have moved the shop 2-3 times before..

 

This is starting to get frustration...

 

Thanks for all help

<{POST_SNAPBACK}>

 

Have you checkd the file permissions in your new host via ftp?

 

It might work if you set the permission to 777 (don't forget to set the appropriate permissions afterwards).

[Geotex]

Yes, if you have Easy Populate installed (and working) on both systems. Also, if you know how to create sql files using Excel, it can be done. Also, if you know the data structures are similiar, you can create individual files from the appropriate tables using phpMyAdmin with the old data base, then upload them to the new one.

 

However, if you are using the same program and data files on the new server, a clean install might be in order, then try uploading your data again from the backup.

[Guest]

Yes, if you have Easy Populate installed (and working) on both systems. Also, if you know how to create sql files using Excel, it can be done.  Also, if you know the data structures are similiar, you can create individual files from the appropriate tables using phpMyAdmin with the old data base, then upload them to the new one.

 

However, if you are using the same program and data files on the new server, a clean install might be in order, then try uploading your data again from the backup.

<{POST_SNAPBACK}>

 

When I log into phpmyadmin and try to upload the database, nothing happens. Is this becouse the "limi" is 2048kb? My database is currently ca. 12-13mb.

If this is causing problems, how do I change it?