Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
How merge All sql files in one Sql file?
Posted 13-Dec-12 20:28pm
ExpertITM1.1K
Comments
OriginalGriff at 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.
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

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?[^]
  Permalink  

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

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 Shai Vashdi 576
1 OriginalGriff 183
2 Tadit Dash 170
3 Sergey Alexandrovich Kryukov 156
4 Peter Leow 130
0 Sergey Alexandrovich Kryukov 9,325
1 OriginalGriff 5,473
2 Peter Leow 4,150
3 Maciej Los 3,540
4 Abhinav S 3,333


Advertise | Privacy | Mobile
Web03 | 2.8.140415.2 | Last Updated 18 Dec 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Use
Layout: fixed | fluid