Moving zencart - cannot find Browser option on SQL tab -help!

[Vger]

I don't know why you'd be getting that error if you dropped the tables from the default setup database, or if you just created a blank database and then run the backup into it.

If you set up the site using the install and then dropped the tables in the default database, then try setting up another blank database and then running your backup sql file into it. If it works then you'd have to edit both configure.php files with the name of the new database.

Vger

[nipinuk]

Thanks Vger,
I dropped the tables from the default setup database admin_zc1 (which had the demo products) so I'm off to try your suggestion.

Some additional info: PHP is run as CGI on my host (Site5)

This is what I've done:
1. Create a blank database called admin_zencart
2. Select "Import" - "Browse" ({filename.sql} which is zipped})
3. Character set of the file: utf8 (this was the default)
4. Click Go

The contents of this new database is exactly the same as the current database.

I've ammended the 'DB_DATABASE' in includes/configure.php and admin/ includes/configure.php

I get the same error with the new database admin_zencart
"1146 Table 'admin_zencart.configuration' doesn't exist"

Your advice is much appreciated,
Linda

[Vger]

Is phpMyAdmin saying that the database import was successful?

Why is the backup database zipped?

Vger

[nipinuk]

From the zencart admin on my original site, I have tried selecting "No Compression (Pure SQL)" instead of GZIP but it just zips it anyway. I noticed that I have not enabled SSL on the admin here. Does it matter for this purpose?

I've just unzipped the file on my pc and dropped the new database admin_zencart and I'm trying to import the sql file from my pc.

It's really strange as Firefox hangs everytime I click on go and I don't get phpMyAdmin saying that the database import was successful. I'm running phpMyAdmin from Site5's cpanel.

I'm getting the error message again. I'm going to try IE6 and see if that makes any difference.

Sorry to keep you up so late,
Linda

[nipinuk]

Just tried IE6. Got the message

" Import has been successfully finished, 404 queries executed."

but I'm still getting the error

"1146 Table 'admin_zencart.configuration' doesn't exist"

Thanks so much for your time Vgers.

I'm giving up for tonight,
Linda

[Vger]

Okay, - there you have your problem - 404 queries executed.

I just backed up a default zen cart database, dropped all of the tables, and imported the backup - which came to 3210 queries.

It looks as though your backup isn't complete.

Vger

[nipinuk]

You're right. The problem is I don't know how to make my backup complete.
I've tried the "Backup MySQL Database" contribution, using export on phpMyAdmin and even copying and pasting the contents of the export file into "Run SQL query/queries on database" on the SQL tab and the results are the same.

I've compared each row of data on my current database and the new database :

Old DB New DB
------- --------
No. of records 4953 4953
Size 824.4 KB 804.6 KB
Overhead 26.5 KB 0 Bytes

The number of records for each table on both databases are the same.

Here are the differences in Size:
Table name Old DB New DB
-------------- ------- --------
zen_admin_activity_log 387.4 KB 386.4 KB
zen_banners_history 17.5 KB 16.5 KB
zen_configuration 138.6 KB 149.6 KB
zen_db_cache 41.3 KB 1.0KB
zen_products 5.8 KB 5.6 KB
zen_sessions 30.1 KB 3.9 KB
zen_whos_online 10.5 KB 8.2 KB

Overhead in Old Database:
zen_customers_basket 36 Bytes
zen_sessions 24,716 Bytes
zen_whos_online 2,400 Bytes

I've checked it at least 3 times and the maths doesn't make sense to me.

I'm not familiar with phpMyAdmin and this is my first go at exporting and importing databases. Have I missed something?

Thanks very much,
Linda

[Vger]

The differences between those two files are minimal and don't account for the fact that only 404 queries are being run. What I think is happening is that the whole backup is not being inserted into the database, which is why you are getting the errors about the missing 'configuration' table. With only 404 queries being inserted it appears that only the tables prior to the 'configuration' table are actually being entered into your database.

What I find unusual about this is that your database is under 2Mbs in size (under 1Mb in fact) and if all of the database cannot load then you should get an error message. There is usually a default time-out of 30 seconds to run a backup into a database, but with the small size of your database it shouldn't be a problem.

In summary there are a few problems:
1. The whole backup is not being inserted.
2. You are not getting any error messages to tell you that.
3. There appears to be a problem with your phpMyAdmin which is preventing the backup from being inserted.

I'm sorry that this provides no solution to your problem, but I'm not even sure that there is one - unless you raise the problem of phpMyAdmin with your hosting company.

Vger

[nipinuk]

Hi Vgers,
I was trying to export and import via php script.
To export,

<?PHP
$User = ""; // Put New user -- CPanel user or MySQL user with All permissions is fine.

$Password = ""; // Put New Password

$DatabaseName = ""; // Put Database name
$File = ""; // Put the complete path here -- /home/user/database.sql for example

$Results = shell_exec( "mysqldump --allow-keywords --opt -u$User -p$Password $DatabaseName > $File");
?>

Called it from the browser and the resulting sql file was only a few hundred bytes. I'm definitely getting in touch with my host now. I'll update everyone.

Thank you so much for your time.

Linda

[Vger]

Let us know how you got on.

Vger