Jump to content

MYSQL


Recommended Posts

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

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


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

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

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...