Other
- Details
- Written by Gregory Cazillo
- Category: Other
Update! November 16th, 2015
Here is an update to an older post, Flickr is now doing this for us, but you need to do it from a single image page NOT the album sharing page. I also suggest using a horizontal photo as the cover photo as it displays better than a vertical. The verticals will fit inside of the height properly and the width of the iframe box will fit into the width of your page as it should. Keep shooting!
Make your flickr photos load responsively! Try resizing this browser window to see how it works.
CSS
.flickrwrap {position:relative;padding-bottom:56.25%;padding-top:30px;height:0;overflow:hidden;} .flickrwrap iframe {position:absolute;top:0;left:0;width:100%;height:100%;}
HTML, be sure to remove the iframe height and width properties from the default flickr code. Change the username and the gallery id number in the src link too, should be good to go!
<div class="flickrwrap"> <iframe src="https://www.flickr.com/photos/cazillo/11409484333/player/" frameborder="0" allowfullscreen webkitallowfullscreen mozallowfullscreen oallowfullscreen msallowfullscreen></iframe> </div>
- Details
- Written by Gregory Cazillo
- Category: Other
I've been moving my servers to Amazon EC2 and have been quite happy with it so far. Today I started setting up a backup script to backup the databases from RDS as well as the web files from the EC2 Instance. I got this error when attempting to execute mysqldump:
mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_QUOTE_SHOW_CREATE=1' at line 1 (1064)
Problem is that the RDS server is running MySQL 5.6 and MySQLDump is only v 5.1 on CentOS 6.4 as of this article. After a bit of googling I found the answer on a Chinese site, translated it via Google Translate and it works great. Hopefully this will help you too!
cd /root
wget http://cdn.mysql.com/Downloads/MySQL-5.6/mysql-5.6.13-linux-glibc2.5-x86_64.tar.gz
tar -xzvf mysql-5.6.13-linux-glibc2.5-x86_64.tar.gz
cp mysql-5.6.13-linux-glibc2.5-x86_64/bin/mysqldump /root
rm -rf mysql-5.6.13-linux-glibc2.5-x86_64
rm -rf mysql-5.6.13-linux-glibc2.5-x86_64.tar.gz
/root/mysqldump [options]Explanation:
- Change directory where you want to permanently store new mysqldump version
- Download MySQL server version, you might need to find newer version or an x86 package file for your distro
- Untar downloaded file
- Copy msyqldump executable to /root folder (or your destination folder)
- Remove other package contents not needed
- Remove tarball not needed
- Always execute mysqldump with complete path instead of just #mysqldump
