Skip to content

Latest commit

 

History

History
28 lines (25 loc) · 1.18 KB

README.md

File metadata and controls

28 lines (25 loc) · 1.18 KB

How to import large database file in php myadmin

  1. create a new database in localhost/phpmyadmin in browser like "personal_blog"
  2. put your .sql file in specific folder
  3. open xampp control panel & click shell button from right side
  4. type this command " mysql -u root -p personal_blog < G:\personal_blog.sql"
  5. Lets enjoy........
  6. if face this problem : ERROR 1813 (HY000) at line 164704: Tablespace for table 'cashbook_live.stock_summeries' exists. Please DISCARD the tablespace before IMPORT
  7. create a new database another name and try ageain. from step 1 .....

How to transfer old database file in xampp manually

  1. copy only folder from old mysql->data folder
  2. Paste this in new mysql->data folder clt+a
  3. go to phpmyadmin in browser and click empty session data
  4. stop php & mysql in xampp server
  5. copy ibdata1 from old data to new data folder
  6. stop php & mysql in xampp server
  7. Lets enjoy........

How to get duplicate row in table

SELECT email, COUNT() as count FROM users GROUP BY email HAVING COUNT() > 1;