Re: Importing database from 1.51 to new install of 1.57c. Products, Customers not loa
Originally Posted by
torvista
What do you mean by this...what error is shown where?
I find importing via phpmyadmin to be very very slow, compared to a command-line operation which takes seconds.
I assume that you are starting with an empty database. In not then remove all the tables and do the import. Or if you are usin phpmyadmin then set the export options
Code:
Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT / TRIGGER statement
Add CREATE TABLE statement
Also on import make sure
Code:
Enable foreign key checks
is unset.
Finally check the size of your file and what your server will allow to be imported. If it is too large you may either have to compact the file (zip it) or break it into bits.
If this is teaching grandma to suck eggs sorry. But thought I would add this as they are issues i have encountered loading databases.
Mark Brittain
http:\\innerlightcrystals.co.uk\sales\
Bookmarks