Newby to MySQL.
I have a MySQL InnoDB setup with various tables. I am working to split out these tables into related databases. For Example, I have a segment of books that I need to seperate out of the Development DB and want to place into a seperate DB called Books. I created the DB for Books and have a Tables section, just wonderin how to copy the table(s) and it's information from Main to Books using either MySQL Admin or Control Center?
Table names = books_master, books_main, books_pages
Database1 = Dev
Database2 = Books
TIA
Rock
I have a MySQL InnoDB setup with various tables. I am working to split out these tables into related databases. For Example, I have a segment of books that I need to seperate out of the Development DB and want to place into a seperate DB called Books. I created the DB for Books and have a Tables section, just wonderin how to copy the table(s) and it's information from Main to Books using either MySQL Admin or Control Center?
Table names = books_master, books_main, books_pages
Database1 = Dev
Database2 = Books
TIA
Rock