You have to remember a few things to successfully import .csv files in the database from phpmyadmin. Save your Excel file as a csv file. Please Do not save it…
Category: MySQL
How to Back Up a MySQL Database in cPanel
May 17, 2020 / MySQLBacking up a MySQL database is something you will need to do if you wish to export it. It also ensures you have a backup copy of your database for…
How to Create a MySQL Database Using the cPanel Database Wizard
June 24, 2019 / MySQLMySQL databases are a way to manage the data needed to operate your website. They are an essential requirement for many website platforms, such as WordPress and Magento. In this…
How to Install Microsoft SQL Server 2014 Express
July 20, 2018 / MySQLBefore starting an installation guide, you need to make sure of a couple of things like, choosing the required version of MS SQL from Microsoft’s website and downloading the right…
How to Reduce/Shrink the SQL Server Database Size
May 15, 2017 / MySQLHere, we have explained all the important steps to shrink or reduce the SQL Server database size (.MDF and .LDF). Method 1: Using SQL Server Management Studio Right-click on the…
How to Create a New Admin Account in WordPress via MySQL
February 2, 2017 / MySQLThe following guidelines undertake that your WordPress database table prefix is set to “wp_”. If you work with something different table prefix, then change your code accordingly. For example, if…
How to change the MySQL Database Collation?
April 11, 2011 / MySQLFew webmasters come asking such questions wherein they have a requirement to change the MySQL collation to overcome issues related to encoding of foreign characters. The best method to do…
Optimize MySQL database
February 8, 2011 / MySQLHow to optimize a MySQL database Usually, for a website having large volume of data, optimizing the MySQL database becomes crucial for enhancing the performance to indexing. Indexing helps in…
How to create a table in PhpMyAdmin
January 7, 2011 / MySQLPhpMyAdmin is an open source application designed and developed in PHP scripting language to perform various tasks, such as creating, modifying or removing database tables, fields of application. It works…