Database performance tuning is important for every application to improve the application speed. Your approach to database performance tuning depends on the issues you are trying to resolve. Here are 10 best practices to help improve database speed and efficiency. 10 database performance tuning best practices Making database performance tuning a routine practice: 1. Keep […]
You can easily do rename table in MySQL using ALTER TABLE statement. In this tutorial, we guide you about how to rename table in MySQL using ALTER TABLE statements. Syntax for rename table in MySQL: The syntax to rename table in MySQL is: Here, table_name refers to your current table which you wish to rename. […]
While importing a large SQL dump file, most of the developers face a common issue that some tables may not be imported properly, errors occurred due to privilege issue, syntax errors, corrupted files. You can exclude those during importing. Use the –force (-f) flag on your MySQL import. Rather than stopping on the offending statement, […]