MySQL - Revision history

Qljca at 10:48, 20 June 2024

2024-06-20T10:48:51Z

@@ Line 42: / Line 42: @@
 chown mysql:root /var/log/mysql-general.log
 chmod 640 /var/log/mysql-general.log
 </pre>
@@ Line 118: / Line 130: @@
 delete from tablemame where Column_ID between 200 and 25134;
 </pre>

2024-06-20T10:43:02Z

@@ Line 9: / Line 9: @@
 mysqlcheck -r DBNAME
 mysqlcheck -o DBNAME
 </pre>

2024-06-20T10:39:06Z

2024-06-19T16:37:45Z

2024-06-19T16:36:48Z

@@ Line 69: / Line 69: @@
 <pre>
 /scripts/update_db_cache
 </pre>

2024-06-19T16:33:07Z

← Older revision		Revision as of 16:33, 19 June 2024
Line 42:		Line 42:
	</pre>		</pre>

	==Import Zip backup==		===Import Zip backup===
	<pre>		<pre>
	gunzip < Backup.sql.gz \| mysql -u USER -p DATABASE		gunzip < Backup.sql.gz \| mysql -u USER -p DATABASE
	</pre>		</pre>

	==Import .tar.gz gzipped==		===Import .tar.gz gzipped===
	<pre>		<pre>
	tar -xzOf your_db_dump.sql.tar.gz \| mysql -u USERNAME -pPASSWORD your_database		tar -xzOf your_db_dump.sql.tar.gz \| mysql -u USERNAME -pPASSWORD your_database

2024-06-19T16:32:27Z

← Older revision		Revision as of 16:32, 19 June 2024
Line 33:		Line 33:
	mysqldump -u DBUser -p --no-data dbname > schema.sql		mysqldump -u DBUser -p --no-data dbname > schema.sql
	</pre>		</pre>


	==Import Databases==		==Import Databases==

	===Import a database===		===Import a database===
	<pre>		<pre>
	mysql -u DBuser -p DBname < dbdump.sql		mysql -u DBuser -p DBname < dbdump.sql
			</pre>

			==Import Zip backup==
			<pre>
			gunzip < Backup.sql.gz \| mysql -u USER -p DATABASE
			</pre>

			==Import .tar.gz gzipped==
			<pre>
			tar -xzOf your_db_dump.sql.tar.gz \| mysql -u USERNAME -pPASSWORD your_database
	</pre>		</pre>

2024-06-19T16:28:36Z

2024-06-19T16:27:55Z

← Older revision		Revision as of 16:27, 19 June 2024
Line 32:		Line 32:
	<pre>		<pre>
	mysqldump -u DBUser -p --no-data dbname > schema.sql		mysqldump -u DBUser -p --no-data dbname > schema.sql
			</pre>

			==Import Databases==
			===Import a database===
			<pre>
			mysql -u DBuser -p DBname < dbdump.sql
	</pre>		</pre>

2024-06-19T16:23:40Z

@@ Line 41: / Line 41: @@
 WHERE table_schema = "database_name"
 ORDER BY (data_length + index_length) DESC;
 </pre>