If this is your first visit, check our documentation. To post, register or login.

Database issues

Locked

Started by robert5 on 18 Jul 2006, 4:54 PM · Views: 1,438

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
18 Jul 2006, 4:54 PM
#1
robert5 avatar

robert5

New Zenner

Join Date:
Jul 2006
Posts:
3
Plugin Contributions:
0

Database issues

I am new to ZenCart - I have a customer who is moving his cart to my server and have no idea how to get his SQL DB up and running.

I reinstalled the software fine - setup a new DB and connected it fine, now I am hoping to populate the db with files I recieved from previous host.

There are 270 files in a tar file.

They seem to match the tables that were setup in the db - but there are only 90 tables.

The files are like this:
address_book.frm
address_book.MYD
address_book.MYI

etc...

Question 1: Which of these, if any, are from/for the DB?

I have tried to import these into the tables but no luck - I have tried SQL, CVS, CSV using LOAD DATA.

I have also tried itf8 and Latin1.

info:
Database: MySQL 5.0.18-standard
PHP Version: 4.4.2 (Zend: 1.3.0)
Zen Cart 1.2.6
Database Patch Level: 1.2.6

Question 2: Is there hope for me?

Any tips extremely appreciated.

Rob

18 Jul 2006, 6:57 PM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: Database issues

robert5:

address_book.frm
address_book.MYD
address_book.MYI
These are raw database files used by the operating system directly. Each table in MySQL consists of these 3 files which work in tandem with one another. They are stored in the operating system folder where all your other mysql database files are kept. Depending on your server configuration, they may have prefixes for a given user-account-name ... ie: fwsmith_address_book.MYD etc
Also, depending on your server configuration, these database files may be actually stored in the user's home directory in a certain specialized folder.

For more information or assistance with webhosting configuration, you might check out the forums at http://www.webhostingtalk.com.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

18 Jul 2006, 7:11 PM
#3
robert5 avatar

robert5

New Zenner

Join Date:
Jul 2006
Posts:
3
Plugin Contributions:
0

Re: Database issues

thanks!

but - these came from Ensim server - I am running cPanel and do not know where raw sql files go - and the naming of dbs etc is very different.

Anyone know if this tranfer is possible?

alternatively can I populate the new database I made with these files in any way?

and - I will post in http://www.webhostingtalk.com, thanks!

Rob

19 Jul 2006, 11:06 PM
#4
vger avatar

vger

Past Contributor

Join Date:
Nov 2004
Location:
Norfolk, United Kingdom
Posts:
3,189
Plugin Contributions:
0

Re: Database issues

now I am hoping to populate the db with files I recieved from previous host.

Obviously they didn't like the customer moving - else they'd have provided you with an sql backup file. Basically - you were stuffed!

On the other hand as this site is a customer of yours then I assume you are providing hosting - in which case you really need to know these things.

If it is still possible then get the old hosts to provide you with a backup of the database.

Vger

20 Jul 2006, 3:27 PM
#5
robert5 avatar

robert5

New Zenner

Join Date:
Jul 2006
Posts:
3
Plugin Contributions:
0

Re: Database issues

Thanks very much - I appreciate your time.
Learning lots every day!

Cheers,
Rob