If this is your first visit, check our documentation. To post, register or login.
Forums / Installing on a Windows Server / Uploading Large SQL files to phpMyAdmin

Uploading Large SQL files to phpMyAdmin

Locked

Started by mike_dean on 5 Jan 2008, 7:45 AM · Views: 4,122

Results 1 to 7 of 7
This thread is locked. New replies are disabled.
5 Jan 2008, 7:45 AM
#1
mike_dean avatar

mike_dean

Totally Zenned

Join Date:
Feb 2006
Location:
Central Coast, NSW, Australia
Posts:
531
Plugin Contributions:
0

Uploading Large SQL files to phpMyAdmin

I'm in the process of doing a site upgrade and have reinstalled zencart on my localhost (Win XP) I have downloaded my existing sql database from my webhost which is approx 34M.

I have created the new database in phpmyadmin using the same file name as the existing database.

I have amened the permissable file sizes in the php config file within WinAmp, but I still get the error regarding the file that I am trying to upload is too large.

Does anyone have any suggestions..????

Norts And Ones
Norts And Ones

5 Jan 2008, 8:12 AM
#2
gsis avatar

gsis

Zen Follower

Join Date:
Jun 2007
Posts:
140
Plugin Contributions:
0

Re: Uploading Large SQL files to phpMyAdmin

We're now settled in at our final home - http://www.swiftbooks.co.uk - where you'll find an eclectic collection of used books. Still a lot of work to do, though!

5 Jan 2008, 8:15 AM
#3
drbyte avatar

drbyte

Sensei

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

Re: Uploading Large SQL files to phpMyAdmin

When working locally or when I need access to large databases, I use the free SQLyog windows application, available at https://www.webyog.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.

5 Jan 2008, 8:22 AM
#4
mike_dean avatar

mike_dean

Totally Zenned

Join Date:
Feb 2006
Location:
Central Coast, NSW, Australia
Posts:
531
Plugin Contributions:
0

Re: Uploading Large SQL files to phpMyAdmin

Thanks guys,

Found out the error, was editing the wrong php config file, I edited the one in C:\Wamp\php instead of C:\Apache2\bin

Changing the values in the correct file really does help..

Thanks for the responses and will also check out the other options next time around

Norts And Ones
Norts And Ones

5 Jan 2008, 8:32 AM
#5
mike_dean avatar

mike_dean

Totally Zenned

Join Date:
Feb 2006
Location:
Central Coast, NSW, Australia
Posts:
531
Plugin Contributions:
0

Re: Uploading Large SQL files to phpMyAdmin

Fixing one problem gives rise to another.

The database uploaded ok (so it would appear), but when I go to //localhost/zencart, I get an error message "...seems to be a problem connecting to our database. Please give us a few minutes...... etc etc etc..

If I try and get into Admin I get another error message

0 DB_ERROR_NOT_CONNECTED in [select * from project_version_key = Zen-Cart Database']

Norts And Ones
Norts And Ones

5 Jan 2008, 8:33 AM
#6
drbyte avatar

drbyte

Sensei

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

Re: Uploading Large SQL files to phpMyAdmin

Is the DB_PREFIX the same in your local PC's configure.php files as it was on your server?

.
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.

5 Jan 2008, 8:40 AM
#7
mike_dean avatar

mike_dean

Totally Zenned

Join Date:
Feb 2006
Location:
Central Coast, NSW, Australia
Posts:
531
Plugin Contributions:
0

Re: Uploading Large SQL files to phpMyAdmin

DrByte:

Is the DB_PREFIX the same in your local PC's configure.php files as it was on your server?

Thanks, yes I verified that and the dabase is the same as the config files in includes and admin includes.

Now all good to go.. Thanks Doc... I can keep a few of my hairs again.. even tho I am a day older tomorrow..!

Norts And Ones
Norts And Ones