mysql

I have a database 260 MB but I have issues when importing my database into Mysql via phpMyadmin, its very slow and sometimes time out. I heard of using bigdump or mysql dumper but not sure how it will works. Do you guys use these tools or having alternatives? what are your best ways to import...

There are many tools to backup and restore databases like MySQL Dumper, Dumper Spydex, Bigdump or using wordpress plugins like BackWPUp, BackupBuddy and they are really very good. However if your database is too big upto several tens of GB then more common tools will get errors and could not...

As title mentioned, I would like to know it is possible to backup Mysql database without using cPanel or Phpmyadmin? there are other ways to backup databases on your hosting without using those tools?

Hey everyone, I figured I would share something we recently learned about getting the best performance out of MySQL and IIS. We recently put up a test Wordpress site. One copy of it on our site, one copy on Amazon Elastic Compute Cloud (EC2). After running some speed tests, we realized our's...

I want to know advantages of types of database management system, MySQL or MariaDB or Percona? Which can work well on a large database? and why?

Hey guys, hope I'm posting this in the right section. I bought a script and now there's a new update which involves going to the phpMyadmin to make some changes. Now every time I try to run a query in the SQL tab, I get this error: Error SQL query: ALTER TABLE `users` ADD `ip` VARCHAR( 45 )...

How can you define MySQL? What it is actually? How to use it in internet?

Primary is a single unique value which is used to identify in database search results, so that we can simple get our unique value. Once we write this primary key in mySQL tables then we can write our php code in website. Every single table in database should contains a primary key. Primary...

Hi guys, Since mysql is undeniably the most popular open-source database tool, then it is practical for those who are like me who are starting to explore on the world of database. Since it is popular, I assume I would easily get a lot of help. Hopefully this will be a good start. My...

Good day everyone, I learned that many web developers are using PHP as their language of choice. It's a simple program to learn, as they say. To those who are just starting to learn like me, there are plenty of references over the internet which are truly helpful. One thing that I also notice...

Hi All I am :confused: How can we create a database using PHP and MySQL? Only expert ... Thanks

how many ways we can retrieve data in the result set of MYSQL using PHP?

Hi everyone, How to Mass Delete Wordpress Comments using Mysql in PhpMyadmin ? Thanks

Hiya guys, if any of you own a dedicated server and want to reduce the MySQL load hopefully I can help. Before doing the following steps it is advised to have had the MySQL service running for at least 24 hours, preferred 48 hours + CentOS: Download MySQLTuner: wget...