i've acquire a database thats about 600mb but i can't open it.
was surprise notepad and notepad++ can't open an sql files thats about 600mb, anyone tried opening a 600mb sql file? what program did you use?
I create a database in MySQL and import the file.
Code:$ mysqladmin -hDBHOST -uDBUSERNAME -pDBPASSWORD create garfish $ mysql -hDBHOST -uDBUSERNAME -pDBPASSWORD garfish Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 36802652 Server version: 5.1.41-3ubuntu12.7-log (Ubuntu) Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> source garfish.sql; ...
Submit Your Webmaster Related Sites to the NB Directory
I swear, by my life and my love of it, that I will never live for the sake of another man, nor ask another man to live for mine.
garfish (14 June, 2011)
Open it also in another SQL softwares like sql server.
Check out intempo android tablet pc here.
Its a software like sql and easy to use.
Thanks for the info I think it's gonna help me too.
Using a sql server will all depend on the sql upload size. If it exceeded the upload size then it will not upload. If you're opening a sql file using notepad ++ and it isn't opening, then your computer performance must be bad.