All About Ubuntu, Magento, Linux thingy, Business Catalyst... and more!
If any of my posts helped you, kindly RETURN THE FAVOR. Just click any of the ADS on this page. Don't worry they won't harm you. Thanks!
Why the name is "I Am The Shadow On The Sun"? It's taken from my favorite Audioslave song - Shadow On The Sun.
Recently, I have an ABC project that uses Web App. I was puzzled how to specify image dimension. I played with the values and finally came up with the correct format. In your web app field that has an 'image' type, simply append the width and height to the image path.
If ever you have encountered the issue mentioned in the title of this post, I have an alternative for that. I experienced that when I imported a very large sql file which is about 2GB.
What I did was I used the mysql command line client. I think you have an idea now how i did it.
But here we go. In your terminal, type mysql -u <your_username> -p. Then type of course type the password when prompted.
Then run use <database_name>; press enter. And then, source sqlfile.sql;
That should do the trick. Just wait for it to finish importing.
To Export all your MySQL databases, do this : mysqldump -u yourusername -p -h localhost --all-databases | gzip > filename.sql.gz
To Import all your MySQL databases, do this : mysql -u yourusername -p -h localhost < filename.sql
Also you might wonder how I unzipped the gz file. You can do this gunzip filename.sql.gz