In this article, I will show you how to dump a mysql database from one server to another remote server without having to export and import your SQL structure and data. We’ll dump a database directly to another empty database on another, remote server. In order to do this, you’ll need shell access to both [...]
Filed under: MySQL, Server Management | No Comments »
The Wordpress mailing list plugin v2.0 has been released to the public with a great set of new features. These features include :
Multiple mailing lists
Email scheduling
Newsletter templates
Automatic updates indicator
Improved sidebar widget with Ajax
Post/page opt-in form embedding
Email queue
CSV and MacOS Address book importing
Excel CSV file exporting
And much, much more…
If you are upgrading from v1.X, you immediately [...]
Tags: emails, mailing, mass mailing, newsletters, plugin, subscribers, Wordpress, wordpress plugin
Filed under: MySQL, PHP, Programming, Web Development, Wordpress, Wordpress Plugins | No Comments »
I know that I was looking for the necessary SQL code to create a countries table, together with the necessary queries to insert all the available countries into this table, each with a unique ID key. So I decided to create it and I’m sharing it with the rest of you whom might need it. [...]
Filed under: MySQL, Programming, Web Development | No Comments »
Sometimes, you need to check if a field exists in a table and if it doesn’t, you need to add it to the table and ensure that its there. Below is a snippet which you can use a reference for checking whether a field/column exists in a MySQL database table.
$tableFields = mysql_list_fields("databasename", "tablename");
[...]
Filed under: MySQL | No Comments »
