Click here to Skip to main content
15,886,199 members
Please Sign up or sign in to vote.
2.00/5 (1 vote)
How merge All sql files in one Sql file?
Posted
Comments
OriginalGriff 14-Dec-12 2:47am    
This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind.
Use the "Improve question" widget to edit your question and provide better information.

I have found a faster way to open the Command Prompt in the right directory with the contest menu.

In your files explorer go to the directory where are your files to merge.
Hold the SHIFT key while you right-click the folder and click on “Open Command Prompt Here”
In the Command Prompt enter : copy *.sql merged.sql hit Enter to copy all data into merged.sql
Close the Command Prompt window.
Open merged.sql in your favorite sql editor and go to the bottom of the content to check if Windows has added an unwanted character, remove it if needed.
All your *.sql are merged into merged.sql you can now import them with few clicks in phpMyAdmin.


How merge All sql files in one Sql file?[^]
 
Share this answer
 
Comments
Alaa Ghallab 1-Aug-14 21:16pm    
Solution 2 is work for me thanks alot bro

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900