Monday, April 1, 2013
Drupal-lovers: Drupal feature Module example
Drupal-lovers: Database Data Fetching using Db_query Codee
How to create Mega Photo gallery in Drupal 7
Drupal-lovers: How to autopost content from my site to facebook
Wednesday, June 20, 2012
Mysql Replication With Phpmyadmin
First Lets go to Replication panel on XAMPP.
Next Select Configure as Master
You can configure Replication as ALL or Selective. I have done selective where I select few DBs to Replicate.
Once you are done you need to add the lines below in the my.cnf file.
# ***** Added Lines here ****
server-id=4745869
log-bin=mysql-bin
log-error=mysql-bin.err
binlog_do_db=saggezza_cats,saggezza_catstesting
# ***** Till Here ****
Here are Ignoring all the DBs for Replication except the two above.
Go to /opt/lampp/etc/my.cnf
Added the lines as I mentioned above above. Also Make sure “max_allowed_packet = 16M”
Make sure to comment out he existing server-id as we have already given above.
Restart XAMPP
$ sudo ./opt/lampp/lampp restart
Once you restart XAMPP, you can see that Mysql Server is started as Master.
Next Lets Create a Replication user and give it privileges as the slave needs this information to connect to the Master.
I have given root but you can give any username you want.
MySQL Slave Configuration
First lets add Server-id to our slave as mentioned.
server-id=9384593
Now lets connect to Master.
You will get a confirmation about he successful connection to Master.
Now we need to start SLAVE I/O and Sql Threads.
They are right under “Control Slave” as below
Now you can see the threads running.
NOTE: If you face any issues getting the threads started then please check logs. In my case IO Thread was not starting. When I checked the log I found that I had two server-id’s in the my.cnf file. Also sometimes you will get IO error due to max_allowed_packet as well, as this is by default set to 1MB, which needs to be around 16MB.
/opt/lampp/var/mysql/mysql-bin
Now we can see all the DBs in Replication Mode. Now any Updates to Master will reflect on the slave.
This will have the MASTER-SLAVE for Mysql Server is Ready.
Thursday, April 12, 2012
How to Mirror Your WordPress Blog to Blogger
Creating a mirror of your blog is a good way to backup your content. In the event that your blog/web host/domain went down, you know that there is another site that is still running, and serving the exact same content.
This tutorial shows you how to mirror your WordPress blog to Blogger.
Why Blogger?
There are plenty of free blog services out there, why choose Blogger? The reason is because Blogger is free and is owned by Google. In term of reliability and stability, it is the best. Since you are backing up your content, isn’t it logical to get it on the most reliable platform around?
Migrating your existing WP blog
The migration from WordPress to Blogger is easy. Log into your WordPress dashboard as Administrator. Go to “Tools -> Export”. Export all your WordPress posts/categories and settings to an xml file.
Go to WordPress2Blogger site. Convert the wordpress.201x-xx-xx.xml to blogger-export.xmlfile.
Login to your Blogger account and go to “Settings -> Import Blog“. Upload the blogger-export.xml file and Import your whole WP blog in.
If everything goes well, all your previously published posts should now be imported into Blogger.
Update Blogger whenever you publish a post
Now that you have imported your previously published posts into Blogger, it’s time to configure your Blogger’s blog to auto-update itself whenever you publish a post in WP.
First, in Blogger, go to “Settings -> Email & Mobile“. Create a new secret email address. This will be the email address that you mail to publish your post. Remember to check the box “Publish emails immediately”. Once done, click “Save Settings”.
Next, I am going to assume that you are using feedburner.com to manage your WP feed, and you have activated the “Email Subscription” option. What you need to do is to subscribe yourself to your own mailing list (preferably with a Gmail address) so that Feedburner can email you whenever you publish a new post.
The last and final thing is to setup your email account to forward the feedburner mail to your Blogger Publish email. In Gmail, this can be done by setting up a forwarding email address and a filter.
That’s it. Whenever you publish a new post in your WP blog, it will be auto-updated on your Blogger blog as well.
What other ways do you use to mirror your WP blog to Blogger?
-------------------------
-------------------------
Instructions
Ever wanted to move your WordPress blogs over to Blogger? This site can aid in the process!
Instructions
|