Big Green Valley Posted July 13, 2009 Report Share Posted July 13, 2009 I don't have a clue what you just accomplished, but if you're happy then I'm happy for you! Congratulations! Quote Link to comment Share on other sites More sharing options...
Strictly Street Posted July 13, 2009 Report Share Posted July 13, 2009 Good for you! Quote Link to comment Share on other sites More sharing options...
DangBruhY Posted July 13, 2009 Report Share Posted July 13, 2009 Output from SQL commands in file backup.sql .. ERROR 1064 (42000) at line 701750: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@font-face Quote Link to comment Share on other sites More sharing options...
RC51 John Posted July 14, 2009 Report Share Posted July 14, 2009 Output from SQL commands in file backup.sql .. ERROR 1064 (42000) at line 701750: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@font-faceSo you broke OR that night.Congrats Ben.Pretty soon I hope to have my MCPD cert. Quote Link to comment Share on other sites More sharing options...
DangBruhY Posted July 14, 2009 Report Share Posted July 14, 2009 This is from a web site database I'm trying to restore. Quote Link to comment Share on other sites More sharing options...
ninjachk08 Posted July 14, 2009 Report Share Posted July 14, 2009 congrats! Quote Link to comment Share on other sites More sharing options...
Earache Posted July 14, 2009 Report Share Posted July 14, 2009 Woot. I'm officially a Certified MySQL 5.1 Database Administrator. Woohoo!Cool - now, can you make my VCR quit blinking "12:00" ? Quote Link to comment Share on other sites More sharing options...
Casper Posted July 14, 2009 Author Report Share Posted July 14, 2009 Output from SQL commands in file backup.sql .. ERROR 1064 (42000) at line 701750: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@font-faceWhat is the sql statement it's trying to run on line 701,750? Quote Link to comment Share on other sites More sharing options...
Casper Posted July 14, 2009 Author Report Share Posted July 14, 2009 Cool - now, can you make my VCR quit blinking "12:00" ?Sweet. Quote Link to comment Share on other sites More sharing options...
DangBruhY Posted July 14, 2009 Report Share Posted July 14, 2009 What is the sql statement it's trying to run on line 701,750? I found out that I might be able to get around it by importing the database within a shell. I needed to brush up on my sql commands. I THINK I got it. I will find out tonight, when I get home. Quote Link to comment Share on other sites More sharing options...
Casper Posted July 14, 2009 Author Report Share Posted July 14, 2009 I found out that I might be able to get around it by importing the database within a shell. I needed to brush up on my sql commands. I THINK I got it. I will find out tonight, when I get home.At the mysql prompt, create the database, then source the sql file.IE:mysql> create database whateveryounamedit;mysql> use database whateveryounamedit;mysql> source c:/nameofdumpfile.sql;You never want to do: mysql -u username -ppassword -h hostname databasename < nameofdumpfile.sql That will give you errors. Quote Link to comment Share on other sites More sharing options...
DangBruhY Posted July 14, 2009 Report Share Posted July 14, 2009 Thanks alot man. I might have to send you a PM with more questions. I'll have to explain my sit-chi-ation. Quote Link to comment Share on other sites More sharing options...
Fonzie Posted July 14, 2009 Report Share Posted July 14, 2009 Congrats Caspatan!This why you've been so MIA lately? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.