Tag: phpmyadmin
-
How to export multiple selected tables in PMA phpmyadmin (but not all tables)
Click on export, and choose “custom” export method. Lets say you want to export first 20 tables only. Open chrome or browser console [ctrl+shift+j], enter the following: For next 20, use 20,50 as arguments in slice function used above.
-
Creating a table in PhpMyAdmin Xampp server.
Hello People. In this post we will discuss that how you can create a table in phpmyadmin xampp server for your php project. Before creating a table first you must create a database, because without database you can not create a table. steps to create a table in phpmyadmin. Start your Xampp server and open…
-
[Forgot Password] [Can’t Log In] How to reset WordPress admin password without sending reset email?
So, admit it. We put really strong passwords and then we forget them. And you end up being locked out of your own website. So here is how you can reset it quickly. Go to your hosting control panel and then go to phpMyAdmin if available. Look into the database which is being used for…
-
Magento 2 : How to fix tablespace for table exists | base table or view already exists
Fixing General error: 1813 Tablespace for table xx Please DISCARD the tablespace before IMPORT and SQLSTATE[42S01]: Base table or view already exists Recently I encountered this error while upgrading an extension on Magento 2.2.2 The error was When I tried to fix the above error, I received: So here is how to fix it: Important…