mysqldump on Fedora 16 slightly OT

Roger arelem at bigpond.com
Sat Sep 8 05:53:55 UTC 2012


HI
I'm hoping Arjen or another mysql guru can help me with a mysql command 
line entry.

I got this command line from Google
mysql mydb1 -u user -p password -e 'select tables like 
"field_data_field%"'| xargs | mysqldump -u user -p password d7x

Where mydb1 is a Mysql database on  my pc, a mysqldump of the server 
database, which has several tables I do need to copy:
  field_data_field, node, taxonomy, user and role to the d7x (drupal 
7)database on my pc.
I need to copy table structure and content.
Apparently the tables are too big for phpmyadmin which seems to be 
particularly limited to miniscule amounts of data.

The command line runs, produces terminal output of each table but puts 
nothing into the tables of the d7x database.

I could copy a table one at a time but there are about 35 and a typo 
could wreck things.


More information about the users mailing list