Activity Stream
48,167 MEMBERS
64921 ONLINE
besthostingforums On YouTube Subscribe to our Newsletter besthostingforums On Twitter besthostingforums On Facebook besthostingforums On facebook groups

Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Hybrid View

maverick79 Having Problem With Mysql Database... 8th Dec 2011, 05:52 AM
maverick79 bump 8th Dec 2011, 06:10 AM
BlaZe Maybe upgrade your MySQL to the... 8th Dec 2011, 06:19 AM
maverick79 well its the latest version and up... 8th Dec 2011, 06:23 AM
Tele try with phpmyadmin 8th Dec 2011, 06:32 AM
KingOfDCP Try using Bigdump. It's simple and... 8th Dec 2011, 09:07 AM
feronso There is no issue with MySQL. its... 8th Dec 2011, 01:45 PM
feronso As i said before, re-upload your... 9th Dec 2011, 08:03 PM
XSLTel could you please paste the first 3... 8th Dec 2011, 01:53 PM
Lock Down Where is the database name in this... 8th Dec 2011, 05:07 PM
NewEraCracker mysql -u hack -p hacker <... 8th Dec 2011, 05:42 PM
maverick79 yes used this method but i can... 8th Dec 2011, 05:59 PM
Lock Down That is very strange as it should... 8th Dec 2011, 08:49 PM
Previous Post Previous Post   Next Post Next Post
  1.     
    #1
    Moderator
    NewEraCracker's Avatar
    mysql -u hack -p hacker < backup.sql

    'hack' is the user-name
    'hacker' is the database name

    password is asked interactively.
    NewEraCracker Reviewed by NewEraCracker on . Having Problem With Mysql Database Upload Hi when iam trying to upload my old mysql database on to my new vps through ssh using the command: mysql -u hack -p hacker <backup.sql its returning me the following error: ERROR 1064 (42000) at line 195527: 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 ''Adobe Premiere Pro CS4 and Adobe After Effects CS4 to Adobe CS5 Rating: 5
    Trusted: Dom, l0calh0st, 0ccul7, robert420
    Find all threads started by NewEraCracker

  2.   Sponsored Links

  3.     
    #2
    Member
    Quote Originally Posted by NewEraCracker View Post
    mysql -u hack -p hacker < backup.sql

    'hack' is the user-name
    'hacker' is the database name

    password is asked interactively.
    yes
    used this method but i can restore only 106 tables out of the 217 tables i have in my database

  4.     
    #3
    Respected Member
    That is very strange as it should never be stopped as an ssh command.

    What happens to cause it to stop or abort?

    I have a 6 gig db on a vps I restore that way and it takes about 4-5 minutes. Your host must having something set wrong.

    Unless you are on a shared host.

Page 2 of 2 FirstFirst 12

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. MySql Database To Large
    By Kat in forum Webmaster Discussion
    Replies: 16
    Last Post: 14th Dec 2011, 10:59 PM
  2. cPanel MySQL Database Upload Help
    By Nickk96 in forum Server Management
    Replies: 3
    Last Post: 19th Sep 2011, 10:28 PM
  3. How to IMPORT MySQL database using SSH in Kloxo On VPS ??
    By The Rock in forum Server Management
    Replies: 9
    Last Post: 18th Jun 2011, 08:00 PM
  4. mysql query to export database
    By lenney in forum IP.Board
    Replies: 4
    Last Post: 7th May 2011, 03:43 PM
  5. Mysql(Database)host
    By Mit1mit2 in forum Hosting Discussion
    Replies: 1
    Last Post: 19th Sep 2010, 07:03 PM

Tags for this Thread

BE SOCIAL