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

[nipinuk]

I'm trying to move my zencart to a different domain which is on the same shared server.

After a few failed attempts I found instructions here which seems to be closest to what I want to do:
http://www.zen-cart.com/forum/faq.ph...switch_servers

I've made a backup of my DATABASE and STORE using "Backup MySQL Database" contribution. I'm stuck at no 5 which gives the following instructions:

5. Go back to phpMyAdmin on your NEW server. - DONE
a. Select your NEW database (that you installed the NEW Zen Cart into)
b. DROP all the tables. (Check them all and scroll down and on "With Selected..." select DROP. Confirm Yes.

PROBLEM HERE:

"c. Click on the SQL tab across the top and click Browse" - WHERE is this? When I click on the SQL tab all I get is a box with this heading "Run SQL query/queries on database zencart" I can't find the Browse option anywhere. I clicked on the Import tab and tried that but it all went haywire and I had to do everything all over again. I'm now stuck here and I'm too scared to "experiment" as there doesn't seem to be an undo button!

Someone please help me! Is there any steps I can omit because it's on the same shared server?

Thank you,
Linda

[DrByte]

I clicked on the Import tab and tried that but it all went haywire and I had to do everything all over again. I'm now stuck here and I'm too scared to "experiment" as there doesn't seem to be an undo button!

The import button is correct.
What do you mean by "haywire"?

[nipinuk]

Thank you so much for your reply. Sorry, by "haywire", I meant to say that the cart didn't display and I panicked and clicked on this and that and I don't know what else and everything was a mess!

I am just about to try the import button - this sounds ridiculous but I'm dreading it!

Will let you know how I get on,
Linda

[nipinuk]

Eeek! - I'm getting the following error message on my store
"1146 Table 'admin_zc1.configuration' doesn't exist"

Linda

[Vger]

There may be some confusion here over the SQL tab issue in phpMyAdmin. Normally there are two SQL tabs.

1. one is immediately above the left column with the list of the database tables and/or database name. This is only suitable fo running individual queries and not for importing whole database backups.

2. The other is a slightly larger link at the top middle of the page. By clicking on this you should see a large box to input SQL queries in, but also a Browse button below it, which you can use to locate your backup file. Once located you can then click the 'Go' button and the backup sql file will be inserted into the database.

Unfortunately some hosts only provide a stripped down version of phpMyAdmin which only has the SQL link for running individual queries.

Vger

[DrByte]

I've been seeing more and more lately that the Browse option isn't on the SQL tab (center screen), but instead under the "Import" tab a bit further to the right.

[nipinuk]

Thanks for your reply Vger. My host is Site5 and I do see both the SQL buttons.

I clicked on the larger tab at the top middle of the page. Looks like I've got the stripped down version as I can only see the SQL link for running individual queries. There's no browse button.

The options I've got at the top middle of the page are:

Structure, SQL, Search, Query, Export, Import, Oprations

I clicked on Import, got my file, clicked go and the only thing that's showing on my store is
"1146 Table 'admin_zc1.configuration' doesn't exist"

I tried searching for that error in forums but there was nothing.

Linda

[nipinuk]

I've been seeing more and more lately that the Browse option isn't on the SQL tab (center screen), but instead under the "Import" tab a bit further to the right.

You're right, the Browse option was under the Import tab.

What should I do? Please? This happened the last time...

Linda

[DrByte]

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

Is "admin_zc1" the real name of the new database ?

[nipinuk]

Yes it is. I've got v1.2.7d installed if that's any help.