Extract tables and insert'em onto a new database, HOWTO???
Posted on 2009-04-22
I have a fedora 9 server, the main reason for the server is running a weather service, and all data is stored on a mysql database (wviewDB) which was created by script by the weather program, and on that database is a table called archive... some time ago I installed wordpress and since was asking for a database, and I now too little close to nothing about creating databases, I setup wordpress using the same database, so now I have more tables on that database...
an upgrade of the weather program has been release, but it ask you to delete the database and all its tables, data won't get lost, since it is using sqllite3 database as the main database, now my question is... how do I create a new database called somethingDB and move all the non weather program tables from wviewDB to somethingDB table, including permissions and stuffs??? and how do I delete the wviewDB???
This are all the tables in the wviewDB database...
Is not like I have lots of stuffs there but... whatever...