Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.

Hot answers tagged

16 votes

How can I tell how big my Amazon RDS database (MySQL) is?

Here are more organized queries against the INFORMATION_SCHEMA Sizes By Storage Engine SELECT IFNULL(B.engine, 'Total') "Storage Engine", CONCAT(LPAD(REPLACE(FORMAT(B.DSize / POWER(1024, pw),...
user avatar
12 votes
Accepted

Make Google index over 90,000 user profiles

Sitemaps can be dynamic just like web pages. Just have a PHP script grab those names from the database and make a loop to echo out the XML for each one. Also, make sure you output the proper content ...
user avatar
  • 85.8k
8 votes
Accepted

How can I tell how big my Amazon RDS database (MySQL) is?

I finally found the easy way to get this information directly from Amazon with a couple of clicks. Log into the RDS management dashboard Click on "DB Instances" Click on the instance in which you are ...
user avatar
6 votes
Accepted

Why can't update.php connect to my database when my site connects to it just fine?

I seem to have resolved this by explicitly adding the socket to the $wgDBserver variable in LocalSettings.php. To get the socket path, I ran this query in my SQL database manager: show variables like '...
user avatar
5 votes
Accepted

Basic looping on PHP for web design

LOOPING There are two methods to loop in PHP: for, and; foreach The PHP for Loop The for loop is used when you know in advance how many times the script should run. Syntax for (init counter; ...
user avatar
5 votes
Accepted

Does Google Show Phpmyadmin URL of site in search result

You've just identified why phpMyAdmin should be only accessible through a protected backend like cPanel... or other means. If Google indexes it, you will be providing a Google Dork, the term for ...
user avatar
  • 2,482
5 votes

How do I access MySQL console on wampserver 3?

In WAMPServer 3, it is in the same place it has always been. You left click the wampmanager icon in the system tray and you will see this menu appear Just like before its called MySQL console
user avatar
4 votes
Accepted

Google Analytics not same with my database records

There are a number of reasons why Google Analytics may not be showing the traffic your database shows... Your Code Is Positioned Poorly Your GA tracking code should be in the head section of the ...
user avatar
4 votes

Can I develop and test WordPress and PHP without a domain name?

This is quite doable. XAMPP should work fine for this. The biggest gotchas will be converting any code that does not use relative addressing to work with a domain and HTTPS. You can likely get closer ...
user avatar
  • 5,825
3 votes

Why do webhosts make you explicitly add which IP addresses can remotely connect to their MySQL databases?

If MySQL servers we open to the general public like your website it would open them up to brute force attacks, and other remote attacks by bots mostly which they simply don't need to deal with. Most ...
user avatar
  • 11.2k
3 votes

What is the best way to exclude bots from view counts?

My approach involves two passes: Filter only web browsers and consoles by matching the start of the user agent string with Mozilla|Opera|PSP|Bunjalloo|wii. Thanks to the user agent spoofing this ...
user avatar
3 votes
Accepted

Magento Backup using mysqldump

Doesn't matter what directory you run the command in, however it will save the sql dump file into the folder your currently in if using SSH to run the command. If you would like to save the file in an ...
user avatar
  • 32.6k
3 votes

Make Google index over 90,000 user profiles

A sitemap does not usually help get pages indexed. See The Sitemap Paradox. To get pages indexed: You need to link to each page from some other page or preferably multiple other pages. Include ...
user avatar
3 votes
Accepted

Where does TWiki store articles: in the file system or in the MySQL database?

TWiki stores content directly in the file system. Look for twiki/data and twiki/pub directories. The twiki/data has directories representing TWiki webs (workspaces). Those webs contain files ...
user avatar
3 votes
Accepted

How to secure database access

No, it's not good practice to create a database user for every site user. The way you have things setup now is pretty standard. It shouldn't be possible for people to get access to passwords stored in ...
user avatar
  • 4,334
3 votes
Accepted

Is it unusual for a hosting company to refuse to update php and mysql?

I have been working for a hosting company and I must say, yes it is pretty normal for small and middle sized hosters and usually has good reasons. If you choose a cheap webspace plan, your site is ...
user avatar
3 votes
Accepted

How to create user in phpmyadmin to connect two servers?

Create the remote connection To create a remote connection: On your database server, as a user with root privileges, open your MySQL configuration file. To locate it, enter the following command: ...
user avatar
3 votes
Accepted

How to export query result in a csv file from phpmyadmin

Previously answered correctly here: https://serverfault.com/a/435443 The answer: Execute your sql query in the SQL tab of phpMyAdmin. After execution, scroll down the page and look for “Query ...
user avatar
  • 146
2 votes

No databases showing in phpMyAdmin

What you should do is to modify $cfg['Servers'][$i]['hide_db'] because it accepts regular expressions so be default there is: $cfg['Servers'][$i]['hide_db']='(mysql|information_schema|...
user avatar
2 votes

No databases showing in phpMyAdmin

This may not help you but it might help someone else. Had installed EasyPHP wamp stack and could create a database in phpMyAdmin but it would not show up in the list of databases. I manually logged ...
user avatar
  • 269
2 votes

How to find out what is causing "Entry Process" limit?

According to this: http://docs.cloudlinux.com/entry_processes_limit.html Entry process limits are designed to prevent hackers from slowing down the server. What you should do is take a closer look ...
user avatar
2 votes

What is the best way to exclude bots from view counts?

You can use an image as a counter, in this case it won't count bots and page name is passed as a query with image name I'm using this at img.php which update page view in database: <?php $xnt = $...
user avatar
  • 121
2 votes

How to check if person doesn't have multiple account?

The actual answer is no you can't! Sure there many things to simulate it. But think of the user uses the other persons computer/account or even browser! You can modify local IP addresses, cookies, ...
user avatar
2 votes

How to create separate users in phpmyadmin, each one can't see others databases?

When you login to phpMyAdmin as the root user you are able to view ALL the databases and perform operations on any of them. If you want to limit access to only a specific user: Create a user for the ...
user avatar
2 votes

How can I tell how big my Amazon RDS database (MySQL) is?

show table status from mydatabsename; where mydatabasename is your database name. This shows you the metrics Data_length and Index_length per table and other metrics. You would have to total these ...
user avatar
  • 32.5k
2 votes

Ubuntu server MySQL remote access from MySQL Workbench

I did a quick search and found these two answers that may help. They seem complete to me where much of the other information I found was too fragmented and incomplete. I like the first link best. ...
user avatar
  • 32.5k
2 votes
Accepted

Virtualmin cannot connect to MySQL database

I found these resources that may help. They explain the errors rather well and what to do about them. Got error: 2013: Lost connection... https://stackoverflow.com/questions/10563619/error-code-2013-...
user avatar
  • 32.5k
2 votes

Possible to have an RDS > 3072GB on AWS?

3TB is massive for the majority of Amazon's customers The majority of Amazon's customers consume far less than 3TB databases in fact the majority will use less than 5GB. The problem with with ...
user avatar
  • 32.6k
2 votes
Accepted

How to block all hacking?

You can prevent hacking to an extent however, nothing is perfect and there are always flaws in any system. Asking a question with such little detail prevents a comprehensive insightful answer. It's ...
user avatar
  • 151
2 votes

How does mediawiki save the passwords?

Hope this helps someone: This is how mediawiki saves the user password in the database. Please see @Aleksander's answer for more details.
user avatar
  • 197

Only top scored, non community-wiki answers of a minimum length are eligible