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
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

Deleting backups - Request to delete customer data - Data Protection Act 1998

Morgan Lewis is a law firm with offices in the UK and they have published information (as of 2012 which is the most recent authoritative publication I can find on the subject) on the ICO's guidance on ...
user avatar
5 votes
Accepted

Should I ask for the state in a registration form for new clients who live in the USA?

Note that having this sort of sub-federal jurisdiction above the level of a municipality happens in many countries, not just in the US (e.g Australia, Canada, China, India, Mexico...) To answer your ...
user avatar
5 votes
Accepted

What are the pros/cons of using remote DB

It's not necessarily a bad idea, assuming DB server/node/gear/droplet/etc is in the same "cloud" and stays on internal bogon routes. A couple cons that could come into play though, depending on the ...
user avatar
  • 3,319
4 votes

Should I ask for the state in a registration form for new clients who live in the USA?

There are fringe cases where zip codes can actually cross state lines. Amazingly stupid, but true: https://en.wikipedia.org/wiki/ZIP_code#By_geography Following trends blindly might be bad UI design ...
user avatar
4 votes
Accepted

Does Amazon's RDS Multi-AZ deployment cost twice as much as the normal cost of a single instance?

Amazon's RDS pricing page has two sections. One for Single-AZ Deployment and one for Multi-AZ Deployment. Yes, Multi-AZ is about twice the price of Single-AZ. For example I see: db.t2.micro ...
user avatar
4 votes

Wordpress database (backup) .sql file got a Trojan category malware treat. Says ESET Internet Security when i try to download the file. What to do?

You do not say what the .sql file is for, however, a .sql file, in of itself, is just plain ol' text and therefore not a threat. Ignore it the notice. It is not uncommon that anti-virus software will ...
user avatar
  • 32.5k
3 votes
Accepted

How do domain names get into WHOIS database and which databases get updated for each domain?

whois is a very poorly defined protocol (or more precisely: defined well enough at the moment it went into use, but now clearly outdated and missing key elements needed today, like tiered access and ...
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
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

Moving website images to remote server vs moving database to remote server

There's no reason that this has to be one way or the other. I would say to optimize both. If you have a large number of images, a CDN makes sense, regardless of what you do on the server. Also, even ...
user avatar
  • 635
3 votes

Hosting company blocks remote access to database. How to deal?

Its difficult to give a good answer without knowing more specifics, but - Remote access to databases is usually disabled because its a security risk with limited upside. In the MySQL world it is ...
user avatar
  • 5,825
3 votes
Accepted

Import Canonical URL for YOAST SEO using Database

Finally After several day, I found the answer in this link: https://larryludwig.com/how-to-make-bulk-edits-to-content-in-wordpress/ from There you can find the the table using this: SELECT * FROM `...
user avatar
2 votes

How do yelp and google business collect information about businesses?

I would say it is mix of all four you mentioned. When the website is small and trying to cover only a small area, they will start by contacting business to list or even get there details and enter ...
user avatar
2 votes

How do yelp and google business collect information about businesses?

Short answer. Simple answer. Most websites primarily buy lists from phone companies and scrape the web. Sometimes they get lists from Chambers of Commerce registries, license registries, Post Office, ...
user avatar
  • 32.5k
2 votes

Will a standard CMS on a shared web hosting account work for this?

Sounds like you have three parts here: User and authorization management Content classification, profiling and/or authorization (possibly done by "tagging" or metadata) Content management--some CMS ...
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
Accepted

What method should I use for copying data from one table to another one?

Depends on the amount of data. If: No large/weird/complex queries No large datasets Rowlocking (innoDB) instead of tablelocking (MyISAM) No absurt amount of users/pagehits Then you have no ...
user avatar
  • 6,736
2 votes

Web user authentication methods

Depending on how users access the site, you might be able to authenticate simply by their IP address. There is also HTTP authentication, both basic and digest. But if you need to differentiate ...
user avatar
  • 40.9k
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

simple database edit webpage recommendations

Have you checked that Google Spreadsheets doesn't already do what you want? It would certainly allow a spreadsheet to be edited from anywhere and by multiple users. You may also be able to use their ...
user avatar
  • 1,925
2 votes

How to change the directory in which MediaWiki is installed after upgrading a temporary directory?

For what I undestood the /codewiki/ is still working with the old database, right? If so, back it up and do the upgrade process again on the live version. You already saw it's working in the /tempwiki/...
user avatar
  • 1,099
2 votes
Accepted

Wordpress DataBase Local Content different from Remote Content

Have you changed the URL in two places in the general settings in the dashboard? If your new test site is actually pointing to the URL of the old site it can cause unexpected results. If you can't ...
user avatar
  • 7,527
2 votes

Wordpress DataBase Local Content different from Remote Content

Wordpress stores serialised data for the links and other essential information about wordpress, what you've done wrong in my opinion is the export of the database. I am using WP Migrate DB plugin to ...
user avatar
  • 1,077
2 votes
Accepted

Is there any downside to using dokuwiki considering it does not use database?

I created a SQL based flat file database that performed 5x (times) faster than MySQL. Amazing!! However, I did find a weak spot. I ran out of iNodes. Ooopppsss!! Still, it supported a website with ...
user avatar
  • 32.5k
2 votes

Is there any downside to using dokuwiki considering it does not use database?

The DokuWiki FAQ answers this question quite extensively. See https://www.dokuwiki.org/faq:database DokuWiki was designed to hold documentation of all kinds. So what do you do when your database or ...
user avatar
2 votes
Accepted

Is it possible to recover the content of a website no more available?

If it happened recently, then you can recover the content from Google cache. I have done this few times. 2 of my clients, forgot to renew the hosting account as result of it, all the source code ...
user avatar
  • 1,277
2 votes
Accepted

Unable to export Magento database using Xampp PhpMyAdmin due to too many input fields that exceed PHP max_input_vars

Export from command line if you have having issues with exporting from phpMyAdmin. backup/export: # mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql restore: # mysql -...
user avatar
  • 2,335
2 votes

Unable to export Magento database using Xampp PhpMyAdmin due to too many input fields that exceed PHP max_input_vars

Add the following lines to php.ini file, max_input_vars = 5000 suhosin.request.max_vars = 5000 suhosin.post.max_vars = 5000
user avatar

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