Hi Everyone,
This is out of general curiosity.
Once you've finished building a website, after all the backwards and forwards playing around, is there a way to reset all of your own page hits data?
- Scott

Hi
Probably the easiest way is to use this.
extensions.joomla.org/extensions/site-ma...ent-statistics/16922
Regards

Hi Mark,
Thanks for your reply and the extension.
- Scott

Hi Scott,

You can also reset all the hits on your site with a simple mySQL query:


where j o s = jos and jos = your database prefix.

Hey Tessa,
Sorry for the slow response.
Would you be able to please explain this a little better for me?
- I'm not sure I fully understand.
- Scott

Hi Scott,

Do you have access to phpMyAdmin?

What hosting server are you using or is it localhost?

Hi Tessa,
Yes I can access phpmyadmin, either on localhost or my live sites.
My use of this area has been to basically create a database or drop a database, and then get the hell out of there before I break something.

I don't really understand what goes on in there so I stay away from it.
I already broke Xampp on my desktop computer and cant reinstall it - when I acidentally deleted something - I thought it was a database but it was something else and then when I tried to uninstall it and reinstall it it wouldn't work, so now I think if I want Xampp to work again I'll have to do a windows reinstall. Anyhow long story short, after that, I don't like to mess around too much in phpmyadmin.

I have seen when I've clicked on an individual database in phpmyadmin (before I click to drop it) that there's this big long list of items in there.
- I'm guessing these are the tables you're talking about?
I don't really know anything else though.
This is where my knowledge in this area ends.

When you ask what hosting server I'm using I'm not sure I know what you mean.
I'm not real good with all the terminology yet.
I think my server is Linux if I understand you right, but I'd have to check.
- Scott

Hi Scott,

Learning about SQL queries is handy, although it's something you can usually avoid because there is usually more than one way to do something.

If you want to learn more, I suggest you do it on a test site, and never on a real site. There are two ways to execute an SQL query. One is from the command line, the other is through phpMyAdmin.

When you're inside phpMyAdmin and you choose a data base, there will be a query tab at the top. Here are some directions I copied from a forum post that show the steps.

1] Go into phpMyAdmin. On the left side, click the name of the database you are using..
2] On the right side, once the page loads, scroll down and find the box that says "Run SQL query/queries on database yourdatabasename" above it.
3] In that box, type (or copy and paste) the query you were told to run.
4] Press the Go button.
5] If your query is successful, it will reload the page and at the very top say "xxx has been yyy" where xxx is the name of the table or field you performed yyy action on, or give a blank white screen. Otherwise, it will give an error message.

You sound a little unsure of yourself in this area. If you want to attempt it, set up another site for testing so you can trash it all you want:) Use the help that comes with phpMyAdmin and ask us questions when you get stuck.

You an also get a lot of help from other forums on phpMyAdmin. Let us know if you want to learn more.

Cheers,
Ed