Hello, I'm looking a Database expert who can solve this problem. I have HostGator hosting....and i just trying to upload a songs lyrics .sql file in "phpmyadmin....i uploaded this file successfully its a 231MB .sql file. I uploaded this file on my wordpress database.....Like..."domain_wrdp3" Its look like this IMG. (lyrics - Yellow Line Table on Top) Now i just want to publish this database like as my wordpress posts....i want to see this like wordpress posts... This DB have i think 167000 Posts...and i don't want to remove my old posts in my site. still in this site, i have 47000+ Posts... Plz help me for this.....if it will work...then i can pay u..... PM me plz of u know how to do this... Thank you
I know there is a way to combine tables in phpMyAdmin if that's what you are looking for. MAKE SURE YOU HAVE A BACKUP OF ANYTHING YOU TRY TO EDIT! Select your table so you can see all the contents, in the bottom right there is a panel that says "Copy table to (database.table):" PLEASE READ THE BIG RED FONT! If your tables have the same layout you should be able to use "Structure and data"I have never used this before so I have no idea how it works. I would suggest doing your research on this before trying unless you think it could work.