mysql dump executed but nothing shows up

[laptop13]

I got a data dump from a supplier and put it through the main database and it said everything was executed successfully. however when i log into admin and catalog, as well as the actual database nothing shows up? any ideas? im a newb when it comes to databasing. thanks for any help

[♥geoffreywalton]

I got a data dump from a supplier

 

Post a sample

 

and put it through the main database

 

how did you do this? Using EP, phpmyadmin?

 

might be able to help then....

[laptop13]

I got a data dump from a supplier

 

Post a sample

 

and put it through the main database

 

how did you do this? Using EP, phpmyadmin?

 

might be able to help then....

Its is a huge database of products, so a sample would only show on peice of the table. I put it in through myphpadmin, would that make a difference? it had said query executed successfully 22*** lines added i think.

[dmnalven]

Were any conversions made to the table and column names and data types required by osC?

[laptop13]

Were any conversions made to the table and column names and data types required by osC?

 

no i do not believe so, the dump was given to me by the company and the guy didn't know what tey used so i read their code and saw OSC in there and downloaded oscom, all the tables matched. so this was a dump from their database. I have CC and it never worked but i'm thinking of switching to oscomm if its benificial.

[dmnalven]

Without knowing the structure and parameters of the dump and the version of osC that you are using, we can not help you. It is very interesting that they supply a dump for osCommerce. Is it known to work and for what version? We also need to know what version of MySQL and PHP you are using.

 

BTW, does CC = CubeCart?

[laptop13]

Yes cubecart. i am using the latest version of OSCom, php and mysql v.4 because that is what the dump came out of. i do not know what version of oscom they are using. is there a way that i could attach such a large file or can you tell me whic portion i would need to post here to see if it is correct?

[highvisualproducts]

Yes cubecart. i am using the latest version of OSCom, php and mysql v.4 because that is what the dump came out of. i do not know what version of oscom they are using. is there a way that i could attach such a large file or can you tell me whic portion i would need to post here to see if it is correct?

 

 

Hi,

 

I also experienced the same problem a few months back, hopefully my instructions below will help and solve the problem!

 

* Back up your files & database

 

* I am presuming you can manually create a MySQL database in your hosting control panel, so create a new database and keep the information stored for later use.

 

* You will now need to upload the mysql dump in myphpadmin to the new database created

 

* Once this is complete you will need catalog/includes/configure.php and catalog/admin/includes/configure.php

 

* Finally you will need to edit both configure.php files i have provided an example below...

 

 

 

// define our database connection

define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', 'rob8294_osc1');

define('DB_SERVER_PASSWORD', 'hu92olnj940');

define('DB_DATABASE', 'rob8294_osc1');

define('USE_PCONNECT', 'false'); // use persistent connections?

define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

?>

 

 

I hope this solves the problem if you need any help just give me a shout!

Good Luck :D

[dmnalven]

Post just the global mysql parameters at the beginning of the dump and the table creation statements for the first table for now.

 

Are you getting any error messages in osC? Have you configured your database connection strings per the post above?

[laptop13]

Hi,

 

I also experienced the same problem a few months back, hopefully my instructions below will help and solve the problem!

 

* Back up your files & database

 

* I am presuming you can manually create a MySQL database in your hosting control panel, so create a new database and keep the information stored for later use.

 

* You will now need to upload the mysql dump in myphpadmin to the new database created

 

* Once this is complete you will need catalog/includes/configure.php and catalog/admin/includes/configure.php

 

* Finally you will need to edit both configure.php files i have provided an example below...

 

 

 

// define our database connection

define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', 'rob8294_osc1');

define('DB_SERVER_PASSWORD', 'hu92olnj940');

define('DB_DATABASE', 'rob8294_osc1');

define('USE_PCONNECT', 'false'); // use persistent connections?

define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

?>

 

 

I hope this solves the problem if you need any help just give me a shout!

Good Luck :D

 

 

both of my configure files have the correct information in them already? is there something i need to change?

[laptop13]

Post just the global mysql parameters at the beginning of the dump and the table creation statements for the first table for now.

 

Are you getting any error messages in osC? Have you configured your database connection strings per the post above?

 

 

here is the first part of it, well a fraction of the over all dump but i think this is what you are asking for.

 

# phpMyAdmin MySQL-Dump

# version 2.4.0

# http://www.phpmyadmin.net/ (download page)

#

# Host: localhost

# Generation Time: Feb 29, 2008 at 01:30 PM

# Server version: 4.0.16

# PHP Version: 4.3.4

# Database : `lamin-xc_p_os1`

# --------------------------------------------------------

 

#

# Table structure for table `categories`

#

 

CREATE TABLE categories (

categories_id int(11) NOT NULL auto_increment,

categories_image varchar(64) default NULL,

parent_id int(11) NOT NULL default '0',

sort_order int(3) default NULL,

date_added datetime default NULL,

last_modified datetime default NULL,

PRIMARY KEY (categories_id),

KEY idx_categories_parent_id (parent_id)

) TYPE=MyISAM;

 

#

# Dumping data for table `categories`

#

 

INSERT INTO categories VALUES (45, 'gmc-logo.gif', 447, 0, '2005-04-14 09:41:37', '2007-02-13 13:16:17');

INSERT INTO categories VALUES (44, 'Cadillac-Logo.gif', 447, 0, '2005-04-14 09:41:13', '2007-02-13 13:13:34');

INSERT INTO categories VALUES (35, 'Ford-Logo.gif', 447, 0, '2005-04-14 09:33:26', '2007-02-13 13:14:45');

INSERT INTO categories VALUES (36, 'honda-logo.gif', 447, 0, '2005-04-14 09:33:57', '2007-02-13 13:17:16');

INSERT INTO categories VALUES (37, 'Mazda-Logo.gif', 447, 0, '2005-04-14 09:35:18', '2007-02-13 13:28:59');

INSERT INTO categories VALUES (38, 'Mitsubishi-logo.gif', 447, 0, '2005-04-14 09:35:42', '2007-02-13 13:29:48');

INSERT INTO categories VALUES (39, 'ferrari-logo.gif', 447, 0, '2005-04-14 09:36:30', '2007-02-13 13:14:32');

INSERT INTO categories VALUES (40, 'lotus-logo.gif', 447, 0, '2005-04-14 09:37:24', '2007-02-13 13:25:30');

INSERT INTO categories VALUES (52, 'landrover-logo.gif', 447, 0, '2005-04-14 09:47:18', '2007-02-13 13:20:44');

INSERT INTO categories VALUES (42, 'chrysler-logo.gif', 447, 0, '2005-04-14 09:40:09', '2007-02-13 13:14:01');

INSERT INTO categories VALUES (66, '94acura.jpg', 31, 0, '2005-04-14 09:58:06', '2007-11-11 10:26:35');

INSERT INTO categories VALUES (34, 'Chevy-Logo.gif', 447, 0, '2005-04-14 09:33:14', '2007-02-27 12:53:14');

[dmnalven]

Well, for starters, the sort orders are all 0. Nothing is going to show until each of the categories has a unique sort order and I would not use 0 to begin. I assume that there is a parent category number 447 and 31.

 

Everything else looks okay so far. The table creation statement matches that used in osCommerce-2.2rc2a.

[highvisualproducts]

both of my configure files have the correct information in them already? is there something i need to change?

 

As long as both configure.php files contain the new database information it should work

E.G

 

// define our database connection

define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', 'rob8294_osc1');

define('DB_SERVER_PASSWORD', 'hu92olnj940');

define('DB_DATABASE', 'rob8294_osc1');

define('USE_PCONNECT', 'false'); // use persistent connections?

define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

?>

 

Please let me know how you get.

 

Louise

[highvisualproducts]

As long as both configure.php files contain the new database information it should work

E.G

 

// define our database connection

define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', 'rob8294_osc1');

define('DB_SERVER_PASSWORD', 'hu92olnj940');

define('DB_DATABASE', 'rob8294_osc1');

define('USE_PCONNECT', 'false'); // use persistent connections?

define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

?>

 

Please let me know how you get.

 

Louise

 

 

And i also found that when i was using the mysql dump it would not work if i was to install oscommerce the default way, I had to manually edit the 2 configure.php files and it would then pick up the database. If i did not do that it would never pick the database up for some reason.

[laptop13]

Well, for starters, the sort orders are all 0. Nothing is going to show until each of the categories has a unique sort order and I would not use 0 to begin. I assume that there is a parent category number 447 and 31.

 

Everything else looks okay so far. The table creation statement matches that used in osCommerce-2.2rc2a.

 

Can you explain the sort order?

and what it would need to be changed too

[laptop13]

Intrestingly, i started small and took one section products and tested it, it seems it had an extra value at the end, probably something specific they had on their end. so i modified all that in textpad. Now it seems if i add them line by line it work, however if i try to add the whole section it just says error ad gives no explination....?

[dmnalven]

The "sort order" is the order that your categories are displayed at your store. In some osC functions a 0 value means 'don't show it'. If two categories have the same sort order either the last one retrieved from the database will show or sometimes nothing will show.

 

Just use an integer for the sort order. I like to space them out, ie. 5, 10, 15, 20, etc, so that I can easily reorder them if I ever wish to. BTW, there is a 3 digit limit, so you can not use a number larger than 999 unless you modify the database table column definition.

[laptop13]

Ok i got them all to work correctley, I took a stock OScom database and deleted the tables pertenint to the dump out and loaded it section by section. So now i have to figure out where to load pictures and thumbnails, then i have to build an all new site around oscom, LOL

[laptop13]

I do have one important question though, this loaded all the catagories into the base catagorys, since this is just a database of a particular product, how can i move it one out.

 

IE

 

car part 1

car part 2

 

make it

 

company #1

>car part 1

> car part 2