Hello, Taking the backup of a single table of a MySQL database and restoring it is possible via command line. You might have done this using phpmyadmin or via other applications, let’s check how this can be done using the command line tool. I am not writing too much, let’s directly move to the steps:NOTE:… Read More »
Hi Guys, This is only a small tip for those use cPanel servers. If you are looking to find the MySQL root password for the server, it’s easy and can be done in a flah of a second. The password is saved in file named .my.cnf under the root directory of your server. Using the… Read More »
Hello, Taking the backup of a single table of a MySQL database and restoring it is possible via command line. You might have done this using phpmyadmin or via other applications, let’s check how this can be done using the command line tool. I am not writing too much, let’s directly move to the steps:NOTE:… Read More »
We Successfully instal WAMP server in localhost for programing, but after installing WAMP server we tryping to access the phpMyAdmin you may encounter the error: #1045 Access Denied for user ‘root’@’localhost’ (using password: YES). This may happen if you provided a wrong password or if your root@localhost database user was not granted the necessary rights… Read More »
Hi Friends, How to find out the last row data from database. It’s very useful to developers. Suppose our table has different field and multiple row values exist. We find the last values from database for some purpose like find the last row values id or something like this. Syntax Select * from table name… Read More »
Hi Friends, Today we discuss one important topic related to ajax like calculate the time difference from current time using ajax in php. In the previous article How to get current Time using JavaScript In here there is little bit changes for solving this problem. Ajax method is helps to solve this problem. Fetch the… Read More »
Good Morning to all…. 🙂 In MYSQL, the MyISAM and InnoDB are the most commonly used storage engine. Both these storage enginee have advantages and disadvantages depending on the specific application. The main and important difference between InnoDB and MYISAM is : the MyISAM does not support the advanced transaction process, and InnoDB support advanced… Read More »
Good Afternoon… I got a query from my blog viewer How to upload images in database by using PHP and angularjs. He tried a lot of time but he can’t upload. Based on this request I try to solve this problem I can find the solution. And here I explain how to solve this situation… Read More »
