mysqladmin
Differences
This shows you the differences between two versions of the page.
mysqladmin [2018/01/03 06:51] – [Show tables and procedure information] admin | mysqladmin [2022/10/29 16:15] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 38: | Line 38: | ||
- Step7: Init database< | - Step7: Init database< | ||
cd /onec/mysql | cd /onec/mysql | ||
- | scripts/ | + | scripts/ |
</ | </ | ||
- Step8: Start Server:< | - Step8: Start Server:< | ||
Line 69: | Line 69: | ||
bin\mysqld --initialize | bin\mysqld --initialize | ||
bin\mysqld --initialize-insecure | bin\mysqld --initialize-insecure | ||
- | </ | + | </ |
- | A temporary password is generated for root@localhost: | + | </ |
+ | ./ | ||
+ | ./ | ||
</ | </ | ||
- Step5: Start the MySQL server:< | - Step5: Start the MySQL server:< | ||
Line 469: | Line 471: | ||
===== Tunning Mysql Server ===== | ===== Tunning Mysql Server ===== | ||
Before run script check, we need to run automatic all pages of websites for running all queries in mysql | Before run script check, we need to run automatic all pages of websites for running all queries in mysql | ||
+ | ==== MySQL table limit ==== | ||
+ | https:// | ||
==== Run script check ==== | ==== Run script check ==== | ||
Download script from https:// | Download script from https:// | ||
Line 703: | Line 707: | ||
</ | </ | ||
* step2: Loading this file using:< | * step2: Loading this file using:< | ||
- | mysql -f --default-character-set=utf8 -u username -p backup_mysql < backup.sql | + | mysql -f --default-character-set=utf8 |
</ | </ | ||
==== Use the mysqlhotcopy script ==== | ==== Use the mysqlhotcopy script ==== |
mysqladmin.1514962287.txt.gz · Last modified: 2022/10/29 16:15 (external edit)