MySQL UTF8 DB Text Fix Read More

  I managed to solved this by adding FcgidBusyTimeout . Just in case if anyone have similar issue with me. Here is my settings on my apache.conf: <VirtualHost *:80> ....... <IfModule mod_fcgid.c> FcgidBusyTimeout 3600 <... Read More

  The issue was that the request was timing out before the script completed, due to a long-running database query. So that generic End of script output before headers error can be caused by server timeouts as well as file permissions... Read More

mysql -u username -p database_name < file.sql   Source: https://stackoverflow.com/questions/17666249/how-do-i-import-an-sql-file-using-the-command-line-in-mysql Read More

  SELECT * FROM `tbl_product2` A LEFT JOIN `tbl_product` B ON A.id_product = B.id_product WHERE B.id_product IS NULL   SELECT * FROM `tbl_product2_lang` A LEFT JOIN `tbl_product_lang` B ON A.id_product = B.id_product WHERE B.id_product IS... Read More

mysqldump -u YourUser -p YourDatabaseName > wantedsqlfile.sql   Source: https://stackoverflow.com/questions/3031412/how-to-export-a-mysql-database-using-command-prompt Read More

mysqldump -u YourUser -p mydb t1 t2 t3 > mydb_tables.sql   Source: https://stackoverflow.com/questions/18741287/mysqldump-exports-only-one-table Read More

bind-address = 127.0.0.1   Ref: https://stackoverflow.com/questions/1559955/host-xxx-xx-xxx-xxx-is-not-allowed-to-connect-to-this-mysql-server Read More

1. Stop mysql: systemctl stop mysqld 2. Set the mySQL environment option systemctl set-environment MYSQLD_OPTS="--skip-grant-tables" 3. Start mysql usig the options you just set systemctl start mysqld 4. Login as root mysql -u root 5. Update the... Read More

ALTER TABLE tbl_content ADD INDEX idx_state (state);ALTER TABLE tbl_content ADD INDEX idx_catid (catid);ALTER TABLE tbl_content ADD INDEX idx_section (sectionid);ALTER TABLE tbl_content ADD INDEX idx_publish (publish_up);ALTER TABLE tbl_content ADD... Read More

SET NAMES utf8mb4; ALTER DATABASE dreams_twitter CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci; Use the following command to check that the changes are made SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR... Read More

Export: mysqldump -u root -p --all-databases > alldb.sql Look up the documentation for mysqldump. You may want to use some of the options mentioned in comments: mysqldump -u root -p --opt --all-databases > alldb.sql mysqldump -u root -p -... Read More