WordPress.org

Forums

mysql dump (2 posts)

  1. quickthinking
    Member
    Posted 1 year ago #

    I am getting this message

    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 ‘Usage: mysqldump [OPTIONS] database [tables] OR mysqldump [OPTIONS] –databa’ at line 1 - See more at: http://www.pushon.co.uk/blog/clever-stuff/easy-fix-for-the-right-syntax-to-use-near-usage-mysqldump/#sthash.kQkBXcQs.dpuf

    this is the solution I see

    To fix this, simply open the sql file in a text editor and remove the first four lines, namely: - See more at: http://www.pushon.co.uk/blog/clever-stuff/easy-fix-for-the-right-syntax-to-use-near-usage-mysqldump/#sthash.kQkBXcQs.dpuf

    My question is...how do I find the sql file to open it with the text editor and make the changes

  2. liton1980
    Member
    Posted 1 year ago #

    If you are going to open a large database, you will face problem in windows text pad and i suggest you to use notepad plus plus which is much faster for opening large files and editing them. It also supports editing SQL files.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.