I have a wrdp1.sql file saved at my pc,and i need to add some tables to this database while some tables are needed to be removed to reduce the size of the database. SO,CAN ANYONE SUGGEST a good offline tool to edit the sql file for this purpose ?
MySQL database? If so, use the MySQL GUI Tools @ http://dev.mysql.com/downloads/gui-tools/5.0.html One more item. I should note that the .SQL file is a plain text file, which can be edited using a text editor.
Why would you recommend the poster use XAMPP to edit .SQL files? He does NOT need a LAMP stack to edit a TEXT file.
because it comes with phpmyadmin, which is far easier than using text files. I would recommend the same, install XAMPP, thats what I do...
XAMPP is good coz it comes with PHPMyAdmin n Apache server option. u dont need to install these things individually if u r using XAMPP.
I am surrounded by ###. Install the COMPLETE stack to edit a .SQL file? Did the original poster ask how to setup a *AMP stack on Windows? No. Use a text editor such as notepad or install MySQL and the GUI tools.
Thanks to all for their suggestions. As it was first suggested, i decided to go with text editor and the gui tool. But i feared that i can corrupt the data as i am not a pro at dealing these stuffs. My hosting support suggested me to use BIGDUMP php script to upload the 40mb .sql database.I tried an i worked !! And i am easy with phpmyadmin interface. Also thanks for suggesting the xampp tool,i must see this too sometimes.