<?xml version="1.0"?>

<rss version="2.0">


<channel>
<title>Home - All Categories - MySQL  - Command Line  </title>
<link>https://www.navel.ir/category/mysql/command-line/</link>
<description>This RSS Feed contains Articles of Category in the knowledge base. You can click on the title to view its content. Powered by PHPKB Knowledge Base Software (http://www.knowledgebase-script.com)</description>
<item>
										<guid>https://www.navel.ir/article/limiting-the-number-of-records-from-mysqldump-20.html</guid>
										<title>Limiting the number of records from mysqldump?</title>
										<link>https://www.navel.ir/article/limiting-the-number-of-records-from-mysqldump-20.html</link>
										<description><![CDATA[mysqldump -u root -p --opt --where="1 ORDER BY id DESC LIMIT 0, 10000" database the_table &gt; the_table_10k.sql &nbsp; Reference: https://stackoverflow.com/questions/135835/limiting-the-number-of-records-from-mysqldump]]></description>

									</item>
<item>
										<guid>https://www.navel.ir/article/mysql-optimize-repair-all-tables-in-one-go-18.html</guid>
										<title>MySQL OPTIMIZE &amp; Repair all tables in one go</title>
										<link>https://www.navel.ir/article/mysql-optimize-repair-all-tables-in-one-go-18.html</link>
										<description><![CDATA[mysqlcheck -o --all-databases -u root -pmysqlcheck -o &lt;db_name&gt; -u root -p=================================================mysqlcheck --auto-repair --check --all-databases -u root -p&nbsp;mysqlcheck --auto-repair --databases &lt;db_name&gt; -u...]]></description>

									</item>

</channel>

</rss>