Results 1 to 10 of 10
Thread: Restore database error
-
07-29-2010, 01:00 PM #1Newbie
- Join Date
- Jan 2010
- Posts
- 27
Restore database error
We are getting the below errors while restoring the sql file.
[root@srv595 mysql]# mysql -uadmin_user-pw324234f admin_database< admin_data.sql
ERROR 1064 (42000) at line 1: 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 'Warning: The option '--all' is deprecated and will be removed in a future releas' at line 1
-
07-29-2010, 01:11 PM #2WHT Addict
- Join Date
- Jun 2010
- Location
- Connecticut
- Posts
- 128
It sounds like mysqldump printed a warning message when you dumped the admin_data.sql file, and this warning was included into that sql file itself. mysql is now trying to parse this warning as an sql query, which is not going to work. I recommend that you open the file in a text editor with line wrapping disabled, and then remove any warning(s) which were written to the top of the file.
█ OLM.net - Web Hosting Solutions @ Your Service
█ Multihomed TIER-1 Network | 24/7 On-site Staff
█ IPv6 Now Available! | Dedicated, Virtual, and Shared Hosting
█ Hosting in Connecticut Since 1996 - 1-800-741-6813
-
07-29-2010, 01:18 PM #3Newbie
- Join Date
- Jan 2010
- Posts
- 27
Hello mydatabase size 1Gb ,I can't edit it
-
07-29-2010, 01:32 PM #4WHT Addict
- Join Date
- Jun 2010
- Location
- Connecticut
- Posts
- 128
Please provide the syntax which was used to create the admin_data.sql file.
█ OLM.net - Web Hosting Solutions @ Your Service
█ Multihomed TIER-1 Network | 24/7 On-site Staff
█ IPv6 Now Available! | Dedicated, Virtual, and Shared Hosting
█ Hosting in Connecticut Since 1996 - 1-800-741-6813
-
07-29-2010, 01:35 PM #5Newbie
- Join Date
- Jan 2010
- Posts
- 27
-
07-29-2010, 01:38 PM #6WHT Addict
- Join Date
- Jun 2010
- Location
- Connecticut
- Posts
- 128
Directadmin is creating a corrupt sql dump, since it contains the warning message. If you have SSH access on the server with Directadmin, I would advise you to directly take the backup yourself by using the "mysqldump" command.
█ OLM.net - Web Hosting Solutions @ Your Service
█ Multihomed TIER-1 Network | 24/7 On-site Staff
█ IPv6 Now Available! | Dedicated, Virtual, and Shared Hosting
█ Hosting in Connecticut Since 1996 - 1-800-741-6813
-
07-29-2010, 02:26 PM #7Corporate Member
- Join Date
- Feb 2008
- Location
- Houston, Texas, USA
- Posts
- 3,262
UNIXy - Fully Managed Servers and Clusters - Established in 2006
Server Management - Unlimited Servers. Unlimited Requests. One Plan!
cPanel Varnish Plugin -- Seamless SSL Caching (Let's Encrypt, AutoSSL, etc)
Slow Site or Server? Unable to handle traffic? Same day performance fix: joe@unixy
-
07-29-2010, 05:30 PM #8Web Hosting Master
- Join Date
- Mar 2009
- Posts
- 2,222
-
07-30-2010, 02:20 AM #9Web Hosting Guru
- Join Date
- Jun 2010
- Location
- India :)
- Posts
- 289
Hi,
I think you got the command wrong. There should be space between -u and admin_user.
mysqladmin -u admin_user -pw324234f admin_database< admin_data.sqlAigen Solutions | http://www.aigensolutions.com
Guaranteed High Quality Outsourced Support
24X7 Server Management |Hourly Sysadmin | Hire Individual Techs
AIM:AigenSales |MSN:aigensolutions |E-Mail: Sales@aigensolutions.com
-
07-30-2010, 06:26 AM #10Temporarily Suspended
- Join Date
- Oct 2003
- Location
- Hanoi
- Posts
- 4,309
Similar Threads
-
During WHM restore of an account backup get error: "Failed to restore the domain"
By tnedator in forum Hosting Software and Control PanelsReplies: 0Last Post: 10-20-2007, 12:33 AM -
Font error after restore database ! Please help!
By justbenice in forum Hosting Security and TechnologyReplies: 5Last Post: 05-17-2006, 06:23 PM -
how to restore database ?
By mrcancel in forum Hosting Security and TechnologyReplies: 6Last Post: 10-04-2005, 09:43 PM -
Database restore help
By galacnet in forum Hosting Security and TechnologyReplies: 3Last Post: 05-05-2005, 11:24 PM -
restore database ?
By constantine in forum Programming DiscussionReplies: 2Last Post: 04-21-2005, 04:28 AM