Sefket Posted July 18, 2012 Share Posted July 18, 2012 Hi, Is there a way to import just one section of your table (Members table) into your forums in less than a hour? I'm copying and pasting each query which is like 10k members which is going to take me a while. I'm sure there is a program out there. There is also 500k posts I have to do and that's going to be a pain to copy/paste. Link to comment Share on other sites More sharing options...
Grumpy Posted July 19, 2012 Share Posted July 19, 2012 Assuming you have phpmyadmin, log in to it. (This is the easiest way, not the most efficient and not the fastest) Go to export > then custom. Select the table you want and click export (possibly with drop if exists statement). Then you can import only that table. I'm also assuming your php limits are set high enough for phpmyadmin to do this. :D If not, well... you know where to find us. lol Link to comment Share on other sites More sharing options...
Sefket Posted July 19, 2012 Author Share Posted July 19, 2012 Assuming you have phpmyadmin, log in to it. (This is the easiest way, not the most efficient and not the fastest) Go to export > then custom. Select the table you want and click export (possibly with drop if exists statement). Then you can import only that table. I'm also assuming your php limits are set high enough for phpmyadmin to do this. :D If not, well... you know where to find us. lol Yeah, that's what I did. I had to scroll through Notepad and kept highlighting words. I forgot to use SSH to do the separate parts for the database.I always used SSH for a complete database. Link to comment Share on other sites More sharing options...
Grumpy Posted July 19, 2012 Share Posted July 19, 2012 Oops. sorry. Misread. Then when using mysqldump tool, append the parameter --where="id = 5" (with the actual condition). to make partial selections. Full docs: http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html So... something like mysqldump -t -u [username] -p [database name] [table name] --where="id =1" > output.sql -t is so you don't generate the table information. aka --no-create-info -u for user... -p for password then select db name and table name. Look at manual for more details. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.