Theres Light At The End Of Every Tunnel, Keep Moving
How to handle waiting for metadata lock A “Waiting for metadata lock” state occurs when a database session tries to change a table’s structure (like ALTER TABLE or DROP TABLE) while another session is still using that table. To keep the data consistent, the database prevents any structural changes until all active transactions on that table are finished. Why This …
Importing MYSQL Database Syntax $ mysql -u username -p database_name < path_to_mysql_file_here Importing existing MYSQL database with filename "wordpress.sql" stored at directory "/home/nishant/", Username is "root", terminal will prompt for asking password. $ mysql -u root -p wordpress < /home/nishant/wordpress.sql Exporting MYSQL Database Syntax $ mysqldump -p -u username database_name > path_to_mysql_file_here Exporting MYSQL database …
MySQL database provides a beautiful feature of Auto Increment Column index. Database table can define its primary key as Auto Increment number and MySQL will take care of its unique value while inserting new rows. Each time you add a new row, MySQL increments the value automatically and persist it to table. But sometime you …