inquire

I am using WordPress 2.6.2.

<Akismet and its API key are not part of your blog. Akismet is a plugin for your blog, and the API key is obtained from your WordPress.com account.>

Thank you for your explantion.

It had been over a year ago, and I had forgotten I obtained the Akismet API key from my WordPress.com account.

Can I use this Akismet API key on multiple blogs or is it one per blow?

<For API Key you are NEVER directed to www.ads-software.com.>

Long ago, I posted a question regarding to setting up a blog on the WordPress.com forums.

I was directed to www.ads-software.com NOT for an API Key, rather to setup and manage my blog.

It has been over a year since I activiated my WordPress.COM account and activiated Akismet.

I never login into my WordPress.COM account.

I was directed to www.ads-software.com because I wanted to manage my own blog.

So, I guess there isn’t a separate www.ads-software.com Akismet account.

<you sign up for a WordPress.com account

.COM! (not org)>

Do you mean long ago, I incorrectly signed up for a WordPress.com Akismet account?

If so, then what should I undo and redo?

<Lives upgrades of this magnitude can always be a problem (theme,widget …).>

I haven’t done much customization of my blog.

<If no chance of testing the update always make a BACKUP first.>

I performed a MySQL backup.

There is wp-content/plugins/askimet folders and a hello.php file

Should the /plugins/askimet folders and hello.php file be deleted?

My old blog doesn’t lives in the root of my site.

I guess I won’t have to add the second blog url into one of the files.

For the second blog is it just a matter of placing the WordPress to 2.6.1 into a different named folder on my server?

<What should we comment on quotes from the Codex?>

Just seeking a confirmation.

Thank you for your reply.

<Also, keep in mind that if you start a new blog, you will NOT be able to simply “re-install” the old sql backup file in it!>

If I wanted to keep my old blog and still setup the new blog

I found Installing Multiple Blogs at

https://codex.www.ads-software.com/Installing_Multiple_Blogs

You can do this whether you have the ability to create multiple databases or are limited to a single database.

I have a single database.

Single Database

As with the multiple databases solution described above, the wp-config.php file will vary for each installation. In this case, however, only a single line will be unique to each blog:

$table_prefix = ‘wp_’; // example: ‘wp_’ or ‘b2’ or ‘mylogin_’

As noted, you may use a prefix of your own making.

I guess I would only have to change the $table_prefix = ‘wp_’; to something else and this would create a separate set of tables within the single database.

Upload each wp-config.php file to its specific root/installation directory, and run the installation.

See Installing WordPress for more information.

https://codex.www.ads-software.com/Installing_WordPress

<wp-config.php should be kept because you will need the info from it even if you want to replace it with a v.2.6.x file.>

Perhaps, I can substitute my old WordPress 2.2 wp-config.php with the WordPress 2.6 to save on having to edit the WordPress 2.6.

But I there is https://codex.www.ads-software.com/Upgrading_WordPress_Extended

If there is not a SECRET_KEY define statement in your wp-config.php file, add one. Beginning with Version 2.5, a SECRET_KEY for salting (strengthening) user passwords was added to the wp-config.php file. To improve the chances your user passwords are not ‘hacked’ here’s an example of the line to add to your wp-config.php file:

(‘SECRET_KEY’, ‘RF63k93hb9shj3klvbn37sjd9a9n”‘); // Change this to a unique phrase.

I guess I should copy and paste data from my old WordPress 2.2 wp-config.php file into the WordPress 2.6 wp-config.php file.

Delete the old WordPress files on your site, but DO NOT DELETE
wp-config.php file;
wp-content folder; Special Exception: the wp-content/cache and the wp-content/plugins/widgets folders should be deleted.
wp-images folder;
wp-includes/languages/ folder–if you are using a language file do not delete that folder;
.htaccess file–if you have added custom rules to your .htaccess, do not delete it;
robots.txt file–if your blog lives in the root of your site (ie. the blog is the site) and you have created such a file, do not delete it.

In your Administration panel, under the Plugins choice, deactivate any Plugins. Because of the changes to WordPress, some Plugins may conflict with the upgrade process.

<If you meant you drop/delete the tables – then that’s OK, that will delete your existing blog from the DB.>

Yes, I meant to drop/delete the tables which would delete the contents.

Thank you for the https://codex.www.ads-software.com/Upgrading_WordPress_Extended link

and your replies to my post.

Hi whooami:

[And youre welcome. You skipped over the fact that I gave you the damn MySQL command. I missed the part where the other person provided you any assistance.]

Thank you.

[Ingrate.]

Keep spreading your goodwill to fellow members.

[Furthermore, youre asking for trouble running 2.0.2]

I am running WordPress 2.2.

I am not having trouble with this version.

Hi bjohnm:

[You know what whooami, Inquire is asking legitimate questions. His question is not about how to use MySQL, but where options need to be changed.]

Correct.

I am using MySQL versus phpAdmin, which phpAdmin is used in the instructions at the link

https://codex.www.ads-software.com/Changing_The_Site_URL

[You know what whooami, Inquire is asking legitimate questions.]

Thanks.

I went to https://codex.www.ads-software.com/Changing_The_Site_URL

I am using mysql to change url of my blog.

I typed the command show tables;

I typed

select * from wp_options where option_name = ‘siteurl’;

The result is 1 row in set

I typed

select * from wp_options where option_value = ‘https://www.myurl/blog&#8217;;

The result is 2 rows in set

My question is to change the URL in the database is the command?

update wp_options set option_value = ‘https://www.newmyurl/blog&#8217; limit 1;

Is there another field that has to be updated in the other row?

[Look for the home field in the table]

I didn’t find a home field in the wp_options table.

[Delete the folder wp-content/cache (this is a new folder added with WordPress 2.0).]

I am using WordPress 2.2.

I didn’t find wp-content/cache folder on my server.

I am using putty to access the database for my blog on my server.

I am using mysql to change url of my blog.

I typed the command show tables;

Does anyone know which table has the field to update the new name?

My guess it might be the wp_options table.

If so, does anyone know the column name to run a select command?

Got it.

Thanks.