mysqldump on Fedora 16 slightly OT

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.
--
users mailing list
users@xxxxxxxxxxxxxxxxxxxxxxx
To unsubscribe or change subscription options:
https://admin.fedoraproject.org/mailman/listinfo/users
Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines
Have a question? Ask away: http://ask.fedoraproject.org


[Index of Archives]     [Older Fedora Users]     [Fedora Announce]     [Fedora Package Announce]     [EPEL Announce]     [EPEL Devel]     [Fedora Magazine]     [Fedora Summer Coding]     [Fedora Laptop]     [Fedora Cloud]     [Fedora Advisory Board]     [Fedora Education]     [Fedora Security]     [Fedora Scitech]     [Fedora Robotics]     [Fedora Infrastructure]     [Fedora Websites]     [Anaconda Devel]     [Fedora Devel Java]     [Fedora Desktop]     [Fedora Fonts]     [Fedora Marketing]     [Fedora Management Tools]     [Fedora Mentors]     [Fedora Package Review]     [Fedora R Devel]     [Fedora PHP Devel]     [Kickstart]     [Fedora Music]     [Fedora Packaging]     [Fedora SELinux]     [Fedora Legal]     [Fedora Kernel]     [Fedora OCaml]     [Coolkey]     [Virtualization Tools]     [ET Management Tools]     [Yum Users]     [Yosemite News]     [Gnome Users]     [KDE Users]     [Fedora Art]     [Fedora Docs]     [Fedora Sparc]     [Libvirt Users]     [Fedora ARM]

  Powered by Linux