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