Empty database?

Hi

I would like to download my stock database. When going to phpmyadmin in the cpanel the stock database shows as containing 0 products.
Where do I find my stock?
Have I gone loopy? :cry:

Thanks, Tina

Check your /includes/configure.php and make sure that you are using the right database, server, path etc.

If the products still show up on your website then they're in some database somewhere.

Vger

Check your /includes/configure.php and make sure that you are using the right database, server, path etc.

Ajeh
I wouldn't have a clue where to look. The shop was originally installed by rentacart.co.uk
Tina :schmoll:

FTP to your website, then go to the 'includes' folder, highlight the configure.php file and click View. The contents of the file should appear in a text programme for you to view. You can see the database name near the bottom of the file.

Vger

This is what I've got (sorry, but no idea what it means)

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', '');
define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty
define('DB_SERVER_USERNAME', '');
define('DB_SERVER_PASSWORD', '');
define('DB_DATABASE', 'waveneyb_shop');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'db'); // leave empty '' for default handler or set to 'db'

// The next 2 "defines" are for SQL cache support.
// For SQL_CACHE_METHOD, you can select from: none, database, or file
// If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache
// or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder
// ie: /path/to/your/webspace/public_html/zen/cache -- leave no trailing slash
define('SQL_CACHE_METHOD', 'none');
define('DIR_FS_SQL_CACHE', '/home/waveneyb/public_html/shop/cache');

?>

Next peek at the file:
/admin/includes/configure.php

Are they both set to the same database?

Are you looking that the correct database in phpMyAdmin?

Ajeh

Thanks for taking out my personal details (smacks self hard & blushes)

This is in admin/configure

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', '');
define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty
define('DB_SERVER_USERNAME', '');
define('DB_SERVER_PASSWORD', '');
define('DB_DATABASE', 'waveneyb_shop');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'db'); // leave empty '' for default handler or set to 'db'

// The next 2 "defines" are for SQL cache support.
// For SQL_CACHE_METHOD, you can select from: none, database, or file
// If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache
// or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder
// ie: /path/to/your/webspace/public_html/zen/cache -- leave no trailing slash
define('SQL_CACHE_METHOD', 'none');
define('DIR_FS_SQL_CACHE', '/home/waveneyb/public_html/shop/cache');

?>

This is what I see in phpmyadmin

:(:schmoll: Tina

Perhaps you need to ask your host where the database really is?

Perhaps you need to ask your host where the database really is?

Hi Kim
I first contacted them about this on a support ticket yesterday morning and followed it up with an email today. Still waiting :no:

I've just realised that my database user name and password in the configure files are not the same as my cpanel login name and password. Does this mean anything?
Thanks again, Tina

No. In cPanel when you set up a database you have to set up a User and Password linked to that database. However, you should also see a list of all databases and the users with access to them. The one which matches what's in your configure.php files is the one that you're trying to backup.

Vger

I didn't set up a database. I paid to have all of this done for me. My host is not answering my pleas for help.
I've got no idea where to turn next.
I'm afraid to add anymore stock as I have no way of backing it up.
Looks like £55 down the drain.
i give up. I'm off to sulk for a few hours.
Thanks anyway, Tina

And the dropdown where you show _stock on the left doesn't have other databases that are perhaps the missing database?

Hi again Ajeh.
This is what I see

and when i look at the 'shop' one I see this

But nowhere can I find my items in the shop.
Going out for a few hours now to clear my head.
Tina :sleep:

Tina,

_shop appears to be the database for your store. You have 23 categories,
correct? If you scroll on down to products, you should see that you have
222 products. I got that number from your store site/All products.

If you click on the browse button in the products table (very left button...
mouse hover over it..make sure it says browse), you should see all your products.

Why not install the MySql Backup module and then you don't have to mess around with exporting in phpMyAdmin. Something about you messing around in there scares me:wink2: . The MySql Backup module will let you do the DB backup from the store admin. You may want to have somebody set it up for you. If you decided to do it as an export in phpMyAdmin then always remember Do Not click on a red x and when choosing any menu items Do Not choose "drop".

You also want to do a backup of the whole DB not just the products tables.

Thanks Tshooter.
I'll go off and have a peep.
Barco, it frightens me a lot more than it does you! :cry:
I've downloaded mysqlbackup & read the txt file. It says to upload to my server, but not exactly where to put it.

i'm a bit calmer now I've had a few hours break, make that a lot calmer :yes:

Thanks again, Tina

Well, I've managed it. I've exported the csv file. It shows image file name and price. However, the title of the product is not shown.