Title: mysql dump
Last modified: August 21, 2016

---

# mysql dump

 *  [quickthinking](https://wordpress.org/support/users/quickthinking/)
 * (@quickthinking)
 * [12 years, 6 months ago](https://wordpress.org/support/topic/mysql-dump/)
 * 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](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](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

Viewing 1 replies (of 1 total)

 *  [liton1980](https://wordpress.org/support/users/liton1980/)
 * (@liton1980)
 * [12 years, 6 months ago](https://wordpress.org/support/topic/mysql-dump/#post-4192297)
 * 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](http://notepad-plus-plus.org)
   which is much faster for opening large files and editing them. It also supports
   editing SQL files.

Viewing 1 replies (of 1 total)

The topic ‘mysql dump’ is closed to new replies.

 * In: [Localhost Installs](https://wordpress.org/support/forum/localhost-installs/)
 * 1 reply
 * 2 participants
 * Last reply from: [liton1980](https://wordpress.org/support/users/liton1980/)
 * Last activity: [12 years, 6 months ago](https://wordpress.org/support/topic/mysql-dump/#post-4192297)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics