How to change Max: 2,048KiB PhpMyAdmin db upload size and increase its size as user requirement in Windows. By default PhpMyAdmin can only able to import Max: 2,048KiB SQL database size which is not so cool, But PHP developers can increase its size as per theirs project requires and upload more then…
Choose UI theme between Original and Pmahomme inside phpmyadmin control panel. There are by default two type of UI themes available inside phpmyadmin control panel. Php web developer can select any theme between them and set by default UI theme. So here is the complete step by step tutorial for Change UI theme…
Solve retry to connect xampp error. Sometimes process of changing username or password into phpmyadmin xampp control panel by mistake you will change its some other settings and it will display you a error message ” MySQL said Cannot connect invalid settings ” and after then phpmyadmin user cannot starts phpmyadmin…
Drop multiple MySQL tables inside database by checkbox selected table selection. Checkbox automatic selection gives us the facility to choose between multiple tables selection so phpmyadmin user can select multiple tables at a single time and delete them combine without deleting one by one. So here is the complete step by…
Import MySQL database including tables with the use of SQL dump(Downloaded) file. Restoring MySQL database backup is one of the most important task after loosing your all data by some software problem, virus problem. But its very easy to get back your complete database by simply using your backup file…
Export your complete MySQL database into .sql file,XML,CSV,MS Excel,JSon,Latex,MediaWiki table,pdf,php array,text,Yaml format. Creating backup means copying your whole MySQL database into single file format and save some other place so if you loose your database for some kind of reason then you must be able to recover your whole database+tables.…
Completely (Truncate)empty all rows, columns(Entire table) inside MySQL table using xampp. Deleting all records from MySQL database are also called as truncate the whole table and removing all the records inside selected table. PhpMyAdmin gives us the ability to remove tables data with one button click selection tool. So here…
