Server Administration
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Codewalkers ForumsOther TechnologiesServer Administration

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Codewalkers Forums Sponsor:
  #1  
Old August 19th, 2003, 12:04 AM
Carol Carol is offline
Codewalkers Newbie (0 - 499 posts)
 
Join Date: Apr 2007
Location: Sunshine Coast Australia
Posts: 23 Carol User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Uploading database files to phpMyAdmin

I am trying to upload a mysql table which i have saved as a .sql file. Its size is around 3.5mb. I am using phpmyadmin v. 2.2.6 on my host's control panel ie the control panel for my company's site.

I go through the motions correctly but nothing is happening. that is, browse to find the file, click on go.

Can someone please suggest what I may not be doing correctly? I've uploaded smaller tables without any problems.

Thanks in anticipation

Carol

Reply With Quote
  #2  
Old August 19th, 2003, 01:02 AM
bakertrg's Avatar
bakertrg bakertrg is offline
Contributing User
Codewalkers Regular (2000 - 2499 posts)
 
Join Date: Apr 2007
Location: Scottsdale AZ, US
Posts: 2,253 bakertrg User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 48 m 45 sec
Reputation Power: 4
Send a message via Yahoo to bakertrg
RE: Uploading database files to phpMyAdmin

are you uploading data, structure or both? It appears as if you are uploading data from the size but if it is both missing ` marks on the structure can cause phpMyAdmin to fail.


Reply With Quote
  #3  
Old August 19th, 2003, 02:24 AM
Carol Carol is offline
Codewalkers Newbie (0 - 499 posts)
 
Join Date: Apr 2007
Location: Sunshine Coast Australia
Posts: 23 Carol User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
RE: Uploading database files to phpMyAdmin

Thanks for that help. It sort of worked. The table did arrive when i checked both boxes, BUT it only uploaded the primary key - all the other fields were null and only uploaded around 1200 of the 28,000 records. This table is fine on my local machine.

Perhaps I am doing something wrong creating the .sql file. I used phpmyadmin - export.

Thanks again

Carol

Reply With Quote
  #4  
Old September 9th, 2003, 01:00 AM
Matt Matt is offline
Contributing User
Codewalkers Specialist (4000 - 4499 posts)
 
Join Date: Apr 2007
Location: Florida
Posts: 4,158 Matt User rank is Private First Class (20 - 50 Reputation Level)Matt User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: 4 h 10 m 20 sec
Reputation Power: 6
RE: Uploading database files to phpMyAdmin

Resolved by lack of activity.

Original poster, please place in unresolved status if you still need help.

Reply With Quote
Reply

Viewing: Codewalkers ForumsOther TechnologiesServer Administration > Uploading database files to phpMyAdmin


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 2 hosted by Hostway
Stay green...Green IT