What is the other way to import database?
-
Im having a problem importing old database to the new databAse. Old database is so big to import using import function on phpmyadmin.i tried to export as an php array but still im having a limit error.any idea?
-
Answer:
If you have server access, do the import there. Its very easy to do if your db is in mysqldump format. http://dev.mysql.com/doc/refman/5.5/en/mysqldump.html
Marc Castrovinci at Quora Visit the source
Other answers
Are they the same instance? In one instance , you can just execut insert into a_bak select * from a; And table a_bak and a have the same struct.
Dehua Yang
Related Q & A:
- What is the best way to distribute an audio/video feed from a computer to TVs over existing indoor coax cable?Best solution by Audio-Video Production
- What is the best way to clean LEGO bricks?Best solution by bricks.stackexchange.com
- What is the best data model and database systems to store social graph?Best solution by Quora
- What is a good way to structure mark-up generating code and avoid the example mess?Best solution by Code Review
- Best way to import Pokemon Black?Best solution by youtube.com
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.