SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
03-17-2008, 06:12 AM
| ||||
| ||||
 Copying tables Hi Folks I'm trying to copy a database table form one database to another on a different server. Is it possible through myphpadmin, or do I need software? If software, do you know of any good programs to do this? Bob -- View this message in context: http://www.nabble.com/Copying-tables...p15951907.html Sent from the MySQL - General mailing list archive at Nabble.com.      |
|
03-17-2008, 06:12 AM
| |||
| |||
| Re: Copying tables On Mon, Mar 10, 2008 at 2:58 PM, skills2go <support@renoandrealestate.com> wrote: > > Hi Folks > > I'm trying to copy a database table form one database to another on a > different server. Is it possible through myphpadmin, or do I need software? > If software, do you know of any good programs to do this? The same question just received an excellent answer from Rolando Edwards about ten minutes ago. Check the archive here: http://marc.info/?l=mysql&m=120517563300467&w=2 -- </Dan> Daniel P. Brown Senior Unix Geek <? while(1) { $me = $mind--; sleep(86400); } ?> |
|
03-17-2008, 06:12 AM
| |||
| |||
| Re: Copying tables On Mon, 10 Mar 2008, Daniel Brown <parasane@gmail.com> wrote: > On Mon, Mar 10, 2008 at 2:58 PM, skills2go > <support@renoandrealestate.com> wrote: >> I'm trying to copy a database table form one database to another >> on a different server. Is it possible through myphpadmin, or do I >> need software? If software, do you know of any good programs to >> do this? > > The same question just received an excellent answer from Rolando >Edwards about ten minutes ago. Check the archive here: > > > http://marc.info/?l=mysql&m=120517563300467&w=2 The one missing piece: mysqldump can choose to dump only one or a few databases, and if given one database name, can dump only selected tables. <http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html>: There are three general ways to invoke mysqldump: shell> mysqldump [options] db_name [tables] shell> mysqldump [options] --databases db_name1 [db_name2 db_name3...] shell> mysqldump [options] --all-databases Read the manual for your version of MySQL for more options. --opt looks like it might be most useful. -- Tim McDaniel, tmcd@panix.com |
|
03-17-2008, 06:12 AM
| ||||
| ||||
| Re: Copying tables On Mon, Mar 10, 2008 at 3:26 PM, Tim McDaniel <tmcd@panix.com> wrote: > On Mon, 10 Mar 2008, Daniel Brown <parasane@gmail.com> wrote: > > The same question just received an excellent answer from Rolando > >Edwards about ten minutes ago. Check the archive here: > > > > > > http://marc.info/?l=mysql&m=120517563300467&w=2 > > The one missing piece: mysqldump can choose to dump only one or a few > databases, and if given one database name, can dump only selected > tables. <http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html>: Good point. I forgot to mention that. Thanks, Tim. -- </Dan> Daniel P. Brown Senior Unix Geek <? while(1) { $me = $mind--; sleep(86400); } ?> |
Linear Mode
