The site you are asking about does not seem to be hosted on WordPress.COM so you need to make friends over at WordPress.ORG the keepers of the software you are using.

http://en.forums.wordpress.com/topic/7-things-to-know-before-posting-in-wordpresscom-forums?replies=1

This site is for support of sites hosted on WordPress.COM. You should address your questions to WordPress.ORG the keepers of the software you are using: http://wordpress.org/support/

For more on the difference: http://support.wordpress.com/com-vs-org/

What's wrong: When I use mySQL custom query on one of pages AND I have some plugins I experience a conflict.

My custom query works well, but plugins show errors (Can't connect to gallery, can't find gallery etc.) or don't show up at all.
Custom query OR plugin -> everything's just fine.

An example of code:
<br /> $username= "wordpress_user";<br /> $password = "wordpress";<br /> $hostname= "localhost"; </p> <p>$dbhandle1 = mysql_connect($hostname, $username, $password)<br /> or die("Unable to connect to MySQL");</p> <p>$selected = mysql_select_db("denco_1",$dbhandle1)<br /> or die("Could not select examples");</p> <p>$result = mysql_query("SELECT szkolenia.temat, wykladowcy.nazwa, wykladowcy.oznaczenie, wykladowcy.id AS wykladowca_id, szkolenia.specjalnosc, szkolenia.id, szkolenia.pokaz FROM szkolenia LEFT JOIN wykladowcy ON szkolenia.prowadzenie = wykladowcy.oznaczenie WHERE szkolenia.pokaz = 'tak'");</p> <p>if(mysql_num_rows($result) > 0) {<br /> while($row = mysql_fetch_object($result)) {<br /> echo "$row->specjalnosc."; }<br />

Plugin code examples:
<br /> [nggallery id=1]<br />
or
<br /> <?php do_action('slideshow_deploy', '74'); ?><br />

Doesn't matter if plugin (or widget) is in the same column with query or in the sidebar / footer. It seems that plugins that need a sql connection don't work when I use it...

What I've already tried:
-Wordpress update (twice, two last versions) -no difference;
-My theme (Atahualpa) update -no difference;
-Switch theme to Twenty Ten and Eleven - no difference;
-rename $username, $password, $hostname and $dbhandle variables -no difference;
-change php handling plugin (3 different)- no difference;
-import tables I need to wordpress database -no difference;
-import tables I need to wordpress database AND change $result = mysql_query("Select..."); to $result = $wpdb->get _results("Select...) -no difference
-add and remove mysql_close(); -no difference;

I'm out of ideas, I'd appreciate your help very much.

I want to restore my posts and comments to my new local blog.

Means:

The site you are asking about does not seem to be hosted on WordPress.COM so you need to make friends over at WordPress.ORG the keepers of the software you are using.

http://en.forums.wordpress.com/topic/7-things-to-know-before-posting-in-wordpresscom-forums?replies=1

This site is for support of sites hosted on WordPress.COM. You should address your questions to WordPress.ORG the keepers of the software you are using: http://wordpress.org/support/

For more on the difference: http://support.wordpress.com/com-vs-org/

My domain and hosting package expired 2 months ago.I didn't extended it.I asked my company to backup my blog but they said i can't.Instead of that , they gave me my mysql backup file.(.sql format)

I don't know anything about MySQL.I tried to install local wordpress blog , and i did.But i can't import my mysql backup.It says :

"#1100 - Table 'pma_tracking' was not locked with LOCK TABLES "

I searched web for it but couldn't find any solutions.I want to restore my posts and comments to my new local blog.

What should I do , anyone ?

To clear up any confusion, WordPress.com and WordPress.org are two different entities.

WordPress.org has complete support and documentation sites for self-hosted/installed versions of WordPress via their Codex and Support Forums.

Everything in the WordPress is fine except that it is not allowed to import my said database into the WordPress. The WordPress has the functionality to import databases from outside. And it has MySQL embedded.

From XAMPP Control Panel ->phpMyAdmin->Database->Import ?€??€?->Choose ->theDatabase->GO, it should import the database correctly.

However, when I tried to import the said database, there is an error message saying: ?€?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 ?€? ?€? at line 1?€?. The strange signs as appeared here are also questions: what are they and how do they come and why not they are solved in the first place?

The MySQL server version I am using is: 5.5.8. My computer operating system is Windows 7 Home Premium.

After failure of attempts to find the right solution to the problem, I have to report and publish this issue, hoping that this problem can be solved as soon as possible.

I wonder if this is a bug or something that is beyond understanding right now. Would you please offer solutions and guidance. Thanks.

Does Habari offer any export formats that match the available importers?

As I'm migrating from self hosted Habari to a blog at wordpress.com, I wanted to know the settings for wordpress.com mysql access (if access is allowed at all.) Essentially, I'm after the password, name of database, and table prefixes of a user trying to connect to a database for wordpress.com.

Thanks in advance,
Joe

<?xml version="1.0" encoding="utf-8"?>
<!--
- phpMyAdmin XML Dump
- version 3.4.3.1
- http://www.phpmyadmin.net
-
- Host: sql.hostname.com
- Generation Time: Jun 02, 2012 at 06:12 AM
- Server version: 5.5.16
- PHP Version: 5.3.5
-->

<pma_xml_export version="1.0">
<!--
- Database: 'database name'
-->

ends with :

</table>
</database>
</pma_xml_export>

i must do smth cause everything is there..i cheked and all my comments, posts are in this .xml

Import the file into your WordPress.COM blog

Dashboard >> Tools

So, I have...
1. Successfully installed WordPress in my WAMP host.
2. Successfully imported my Joomla posts into my WordPress WAMP installation.

Now what do I do to get import them into my WordPress.com account?

G

@TT, yes, the price of living in paradise. :-)

I had not thought of doing it that way. I already have a functioning WAMP server on my computer. Do you know if that should work for installing the WordPress system?

G