Client Login 
Community 
Contact Us 
LinkBack URL
About LinkBacksThe DB I need to load is 1-2 GB. Is there any way around the 51,200 KB limit in phpMyAdmin? Otherwise, I really do not look forward to loading a bunch of pieces at a time.
Welcome to the JaguarPC Community
Results 1 to 15 of 19
This is a discussion on easiest way to load somewhat large Database in the Shared & Semi-Dedicated forum
The DB I need to load is 1-2 GB. Is there any way around the 51,200 KB limit in phpMyAdmin? Otherwise, I really do not ...
-
10-06-2005, 08:01 AM #1JPC Senior Member
- Join Date
- Mar 2005
- Posts
- 64
easiest way to load somewhat large Database
-
10-06-2005, 08:03 AM #2Resident Alien
- Join Date
- Aug 2002
- Posts
- 398
Do you have it uploaded to your space already?
Originally Posted by EliteRides
If so you might want to open a support ticket and have them do it for you.Looking Out - Playing Bloodletting
-
10-06-2005, 12:05 PM #3Yeah, I know a LOT!
- Join Date
- Mar 2003
- Location
- Arizona Uplands
- Posts
- 10,775
Install your own phpMyAdmin...
DISCLAIMER Any resemblance between the views expressed above and those of the owners and operators of this system is purely coincidental. Any resemblance between these views and my own are non-deterministic. The existence of Vin DSL is questionable. The existence of views in the absence of anyone to hold them is problematic. The existence of the reader is left as an exercise in the second-order coefficient.
No Guts, No Story! VinDSL © 2010
-
10-06-2005, 04:16 PM #4JPC Senior Member
- Join Date
- Mar 2005
- Posts
- 64
No. It is not loaded currently. I didn't bother taking the time if it wouldn't do anything. Thought I'd ask first.
Hmm... Didn't think about doing that. Is it likely to tie up the server resources/crash? Originally Posted by Vin DSL
Install your own phpMyAdmin...
-
10-06-2005, 07:45 PM #5Yeah, I know a LOT!
- Join Date
- Mar 2003
- Location
- Arizona Uplands
- Posts
- 10,775
Nope! Totally 100% stable. You (I) can set it up in 5 minutes... Originally Posted by EliteRides
DISCLAIMER Any resemblance between the views expressed above and those of the owners and operators of this system is purely coincidental. Any resemblance between these views and my own are non-deterministic. The existence of Vin DSL is questionable. The existence of views in the absence of anyone to hold them is problematic. The existence of the reader is left as an exercise in the second-order coefficient.
No Guts, No Story! VinDSL © 2010
-
10-07-2005, 07:57 AM #6Community Leader
- Join Date
- Sep 2001
- Location
- Rochester, NY
- Posts
- 6,003
If you have SSH access you can also upload the file and then run the mysql command line utility to insert the records. That's probably the quickest way to get it done.
mysql -v -u siteusername_mysqlusername -p sitename_dbname < dumpfile.txt
You'll be prompted for a password and then the database will be built.
If you don't have SSH access you can request it from support. Then go download a copy of PuTTY at http://www.chiark.greenend.org.uk/~sgtatham/putty/ and you'll be good to go.
--Jason
-
10-07-2005, 08:09 AM #7JPC Senior Member
- Join Date
- Mar 2005
- Posts
- 64
Is there putty for Mac?
@ Vin. I'm thinking I might do that. I'll have to contact support. Thanks.
-
10-07-2005, 09:52 AM #8Community Leader
- Join Date
- Sep 2001
- Location
- Rochester, NY
- Posts
- 6,003
I thought there was, but I guess not. OS X already has an SSH client built in, though. Just open a terminal prompt and type Originally Posted by EliteRides
ssh username@domainname.com
Username should be your CPanel username. IF you leave that off and just use your domain name it will try to log you in using your OS X username.
--Jason
-
10-09-2005, 06:22 PM #9JPC Senior Member
- Join Date
- Mar 2005
- Posts
- 64
How can I do this with the IP? I have not changed my DNS to propogate yet. I am waiting until I have the database uploaded. I was able to connect with
But it would not accept my password.ssh username@IP
-
10-09-2005, 07:15 PM #10Loyal Client
- Join Date
- Aug 2002
- Posts
- 7,307
I'm not sure, but try username@ servername.nocdirect.com
Good luck!
-
10-10-2005, 08:29 AM #11Community Leader
- Join Date
- Sep 2001
- Location
- Rochester, NY
- Posts
- 6,003
username@IPaddress should work, too. But by default SSH is disabled. You need to open a support ticket and ask for access. If you haven't done that, its probably why you can't log in. Originally Posted by Ron
--JasonLast edited by jason; 10-10-2005 at 08:31 AM.
-
10-10-2005, 08:39 AM #12Loyal Client
- Join Date
- Aug 2002
- Posts
- 7,307
Good point! Originally Posted by jason
-
10-10-2005, 09:24 AM #13JPC Senior Member
- Join Date
- Mar 2005
- Posts
- 64
Yes, I had already requested access previously and I was informed I already have full access.
I am assuming it is the same password as provided for admin access with my new JPC account? Or, do I need to create one in the admin panel?
-
10-10-2005, 12:34 PM #14the Windlord
- Join Date
- Jun 2002
- Posts
- 2,562
It is the same and it will change along with whatever you change the password to in cPanel.
Regards,
Wim Heemskerk
---
Visit MeCCG.net - Cardgaming in J.R.R. Tolkien's Middle-earth
And Gwaihir.net - The Middle-earth CCG store
-
10-18-2005, 02:52 PM #15JPC Senior Member
- Join Date
- Mar 2005
- Posts
- 64
Where is "dumpfile.txt" relative to? Will it execute if I put in in the root directory? Do I need to include "public_html" kind of things anywhere, etc. Originally Posted by jason
Reply With Quote
Posting Permissions
Get Social:
Copyright © 2011 JaguarPC.com
Bookmarks