How to export with limit the number of records from mysqldump?

Wed, 11/25/2015 - 03:36

mysqldump --opt --where='1 limit 10' -h IP_ADDRESS -u USER_NAME DATABASE_NAME TABLE_NAME > databasetable.sql

Tags
MySQL
  • 13 views

Add new comment

About text formats

Restricted HTML

  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type> <li> <dl> <dt> <dd> <h2 id> <h3 id> <h4 id> <h5 id> <h6 id>
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.
12 + 8 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.

Instagram Without API

Could not reach Instagram server