Welcome to MobyThreads.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in
All support for the MobyThreads Threaded phpBB MOD can now be found on welsolutions at this forum

mysql question

  
   Web Hosting and Web Master Forums (Home) -> Webmaster RSS
Next:  Source of old IE browsers  
Author Message
viper

External


Since: Jul 04, 2003
Posts: 149



(Msg. 1) Posted: Sun Aug 10, 2003 4:18 am
Post subject: mysql question
Archived from groups: alt>www>webmaster (more info?)
Ok I have a .sql file thats 30MB in my home dir... I need to use SSH to put
it in the database because it wont work with doing it via phpmyadmin... Can
anyone remind me what the line is again to do this via SSH?

Thanks....

--
Viper
http://www.zurax.com
Webmasters add our search box to your site and get paid!


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.506 / Virus Database: 303 - Release Date: 8/1/2003

 >> Stay informed about: mysql question 
Back to top
Login to vote
viper

External


Since: Jul 04, 2003
Posts: 149



(Msg. 2) Posted: Sun Aug 10, 2003 8:03 am
Post subject: Re: mysql question [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Viper wrote:
 > Ok I have a .sql file thats 30MB in my home dir... I need to use SSH
 > to put it in the database because it wont work with doing it via
 > phpmyadmin... Can anyone remind me what the line is again to do this
 > via SSH?
 >
 > Thanks....

Well I tried and got errors... which make it stop.. Sad
For the one site I am uploading I got this...
ERROR 1062 at line 17559: Duplicate entry 'a5ecd7e3ca14fcb38a69343d1d47985a'
for key 1
For the other... Sad
ERROR 1062 at line 1: Duplicate entry '11335' for key 1

Is there a way to "force mysql to keep going when it runs into an error?



--
Viper
<a style='text-decoration: underline;' href="http://www.zurax.com" target="_blank">http://www.zurax.com</a>
Webmasters add our search box to your site and get paid!


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.506 / Virus Database: 303 - Release Date: 8/1/2003<!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: mysql question 
Back to top
Login to vote
viper

External


Since: Jul 04, 2003
Posts: 149



(Msg. 3) Posted: Sun Aug 10, 2003 10:29 am
Post subject: Re: mysql question [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Viper wrote:
 > Ok I have a .sql file thats 30MB in my home dir... I need to use SSH
 > to put it in the database because it wont work with doing it via
 > phpmyadmin... Can anyone remind me what the line is again to do this
 > via SSH?
 >
 > Thanks....

Thanks all I got it.. fixed the errors too Razz


--
Viper
<a style='text-decoration: underline;' href="http://www.zurax.com" target="_blank">http://www.zurax.com</a>
Webmasters add our search box to your site and get paid!


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.506 / Virus Database: 303 - Release Date: 8/1/2003<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: mysql question 
Back to top
Login to vote
dorward

External


Since: Jun 27, 2003
Posts: 195



(Msg. 4) Posted: Sun Aug 10, 2003 11:15 am
Post subject: Re: mysql question [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Viper wrote:

 > Ok I have a .sql file thats 30MB in my home dir... I need to use SSH to
 > put it in the database because it wont work with doing it via
 > phpmyadmin... Can anyone remind me what the line is again to do this via
 > SSH?

mysql < myfile.sql

--
David Dorward <a style='text-decoration: underline;' href="http://dorward.me.uk/" target="_blank">http://dorward.me.uk/</a><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: mysql question 
Back to top
Login to vote
blogan

External


Since: Jun 30, 2003
Posts: 285



(Msg. 5) Posted: Sun Aug 10, 2003 10:33 pm
Post subject: Re: mysql question [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
"Viper" <viper.DeleteThis@venomx.com> wrote in message
news:tIGdncHJHKk3SKiiXTWJhw@comcast.com...
 > Ok I have a .sql file thats 30MB in my home dir... I need to use SSH to
put
 > it in the database because it wont work with doing it via phpmyadmin...
Can
 > anyone remind me what the line is again to do this via SSH?
 >
 > Thanks....
 >
<a style='text-decoration: underline;' href="http://www.mysql.com/doc/en/Windows_and_SSH.html" target="_blank">http://www.mysql.com/doc/en/Windows_and_SSH.html</a>

Alternatively use MySqlFront or SQLyog<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: mysql question 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
mySQL Question (i think) - Hi all, I was wondering if there was a script or program, perhaps using mySQL, that would allow me to show an active inventory on a website? The desired function would be having the inventory adjust itself and shows current inventory count on the..

MySQL and Text/textfile question - Doing a site for a client that will hold user information including the usual name/address/ect... and a resume. Going to use MySQL to keep track of things, but have a question about the resume/resume file. What would be the best way to store it? Store...

Help with MySQL - hi i am building a site from my pc using APACHE/ and all that other stuff need a little help... Now i want to add some php stuff )INSTALLED AND WORKS( , but this needs mySQL )INSTALLED AND WORKS( how would i setup the databases (named: dbase) : before on...

MySQL and PHP coding help - Hey all, I'm currently redesigning a website that a friend and I started about a year ago. It is a daily surf report so when choosing the best script/language to use for the new design, I asked in here and found that a mixture of PHP and MySQL would be a...

zip question - Hope someone can shed some light on this for me. Thing is im moving servers soon and need to transfer over my databases, I can create the accounts easy enough, and have no problem modifying the databases so things work ok. The problem i have is how do ...
   Web Hosting and Web Master Forums (Home) -> Webmaster All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]