or
To move a table from one mysql database to another,
1) Open phpmyadmin >Select table in phpmyadmin >Export table
2) Open file with editor like Notepad++ >Select ‘SQL’ with phpmyadmin >Paste the entire query that begins with ‘Create Table in NOT Exists’.
Note: You should have 2 queries. One for the new table creation and one for inserting the table data.
2) Select the new database table >Click ‘SQL’ >Paste the query that begins with ‘INSERT INTO’ > Click Go
© 2018 ALL Rights Reserved | Sitemap
Vancouver | North Vancouver | Burnaby | Richmond | Coquitlam | Port Coquitlam | Surrey | Langley | Maple Ridge | Mission | Abbotsford | Kamloops | Kelowna | Victoria | Squamish | Whistler | Pemberton