Lost Password?

Go Back   CodeCall Programming Forum > Web Development Forum > Database & Database Programming
Reload this Page Import SQL file command line
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Unregistered, Check out the Coder Battles in the Announcement and Game forums.

Database & Database Programming MySQL, Oracle, SQL, PL/SQL, ABAP, Smart Forms, and other databases and languages. A database is an organized body of related information used in many websites (including CC).

Reply
Page 2 of 2 < 1 2
 
LinkBack Thread Tools Search this Thread Display Modes
  #11 (permalink)  
Old 01-23-2008, 12:55 PM
zerostar's Avatar   
zerostar zerostar is offline
Newbie
  
Join Date: Jan 2008
Posts: 12
Credits: 0
Rep Power: 0
zerostar is on a distinguished road
Default
ok figured out what my issue was and yes - n00bness at work...

I had already logged into mysql.exe when I was trying to execute the command. I had to back out to the bin directory and then run the command.

up and running (*yay!*)
__________________
::
[ z ]
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #12 (permalink)  
Old 01-25-2008, 09:36 AM
Crane's Avatar   
Crane Crane is offline
Programming Expert
  
Join Date: Nov 2005
Posts: 399
Credits: 1
Rep Power: 13
Crane is on a distinguished road
Default
From inside mysql you can paste the entire contents of the SQL dump. that will also work although I've not tested it.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #13 (permalink)  
Old 01-25-2008, 11:26 AM
John's Avatar   
John John is offline
Co-Administrator
  
Join Date: Jul 2006
Age: 20
Posts: 3,236
Last Blog:
Passwords
Credits: 877
Rep Power: 20
John has much to be proud ofJohn has much to be proud ofJohn has much to be proud ofJohn has much to be proud ofJohn has much to be proud ofJohn has much to be proud ofJohn has much to be proud ofJohn has much to be proud ofJohn has much to be proud of
Send a message via AIM to John Send a message via MSN to John
Default
If you dont want to use the command line, you could always use phpMyAdmin - and for importing large files in which phpMyAdmin cannot handle, you can use BigDump [ BigDump: The Staggered MySQL Dump Importer ]
__________________

To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.

Chat with other CodeCall members on IRC; connect to irc.codecall.net and join #codecall
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #14 (permalink)  
Old 01-25-2008, 02:20 PM
zerostar's Avatar   
zerostar zerostar is offline
Newbie
  
Join Date: Jan 2008
Posts: 12
Credits: 0
Rep Power: 0
zerostar is on a distinguished road
Default
Thanks for the tips

I was hitting the large file size limitation in phpma and I've been wanting to learn up the cmd line functions anyhoo.

<< glutton for punishment
__________________
::
[ z ]
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #15 (permalink)  
Old 01-25-2008, 02:56 PM
John's Avatar   
John John is offline
Co-Administrator
  
Join Date: Jul 2006
Age: 20
Posts: 3,236
Last Blog:
Passwords
Credits: 877
Rep Power: 20
John has much to be proud ofJohn has much to be proud ofJohn has much to be proud ofJohn has much to be proud ofJohn has much to be proud ofJohn has much to be proud ofJohn has much to be proud ofJohn has much to be proud ofJohn has much to be proud of
Send a message via AIM to John Send a message via MSN to John
Default
I just found out about BigDump a few weeks ago. I too was trying to import a large sql file, but couldn't figure out the **** command. Then I came across BigDump and it works great. Especially for those who don't have command line access.
__________________

To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.

Chat with other CodeCall members on IRC; connect to irc.codecall.net and join #codecall
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

Sponsored Links
Reply
Page 2 of 2 < 1 2

« Previous Thread | Next Thread »


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Project: ionFiles - Joomla Simple File Download Jordan Community Projects 303 09-25-2008 02:28 PM
Windows XP Tricks & Tips!!!!..new ones. pranky Tutorials 9 08-23-2008 03:22 PM
Project: ionFiles - Joomla Simple File Download - Mirror 2 Jordan ionFiles 3 04-07-2008 03:09 PM
Best program for SQL database manipulation Rhadamanthys Database & Database Programming 3 07-02-2007 02:32 PM
text file manipulations in vb6.0 Ronin_paes Visual Basic Programming 3 06-11-2007 04:54 AM


All times are GMT -5. The time now is 02:17 PM.

Contact Us - Programming Forum - Archive - Top

CodeCall

Contest Stats

Xav ........ 1315.71
MeTh0Dz|Reb0rn ........ 1053.7
morefood2001 ........ 879.43
John ........ 877.37
marwex89 ........ 869.98
WingedPanther ........ 814.88
Brandon W ........ 710.1
chili5 ........ 300.72
Steve.L ........ 231.06
dargueta ........ 192.86

Contest Rules

CodeCall Goal

Goal: 100,000 Posts
Complete: 82%

Sponsors

Linux Forums
Electronic Music
Podnet IRC Network

Ads