7 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 ...
Stephen Ostermiller's 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 ...
Chris Rutherfurd's 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 ...
dhaupin's user avatar
  • 3,339
4 votes

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

To estimate the RDS cost I recommend the AWS Simple Monthly Calculator. For a db.m4.large PostgreSQL instance I get the following: Single-AZ - $140.13/month - no High Availability Multi-AZ - $280.25/...
czerasz's user avatar
  • 141
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 ...
closetnoc's user avatar
  • 32.8k
4 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 `...
Rakis Friski's user avatar
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 ...
DKing's user avatar
  • 645
3 votes

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

Old thread but it's searchable... If you run multiple instances in multiple AZs, of course you pay for each instance. There is some additional data replication costs but the BIG miss here is that you ...
Michael Geiser's user avatar
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
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 ...
Tim Fountain's user avatar
  • 4,454
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 ...
davidgo's user avatar
  • 7,550
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 ...
selfthinker's user avatar
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 ...
closetnoc's user avatar
  • 32.8k
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 ...
knif3r's user avatar
  • 1,067
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
Abdul Majeed's user avatar
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 -...
Analog's user avatar
  • 2,355
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 ...
Mani's user avatar
  • 1,317
2 votes

What are the pros/cons of using remote DB

The answer depends on the environment you are running. If only a single machine will be accessing the database, in other words you only have one web server then ideally you would run the database on ...
Chris Rutherfurd's user avatar
2 votes
Accepted

Using mySql database data directly into generating articles for my website? (newbie, needs to know where to start))

You are looking for two different solutions. Generating the articles from MySQL requires backend code like Java or PHP, along with the database MySQL. The sorting requires frontend code like ...
Zach Voss's user avatar
  • 126
2 votes
Accepted

Backend method to changing base wordpress domain to prevent redirect

The answer by Stephen's Ostermiller ♦ is correct but sometimes you can run into problems even when updating the site address, this is due to the fact that plugins don't always update their paths when ...
Simon Hayter's user avatar
  • 32.9k
2 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?

It is not uncommon for malicious JS to be injected and stored in a database. If this is a backup copy of your site's database, it may contain elements that have been identified as malicious. It looks ...
gnicko's user avatar
  • 256
2 votes

Tell wordpress to save and organize images into folders?

Yes, it is possible. Yes, it is a good idea (for all sorts of reasons, from simplifying management to SEO). There's a load of plugins designed to do just that. Just search for "wordpress media ...
GeoffAtkins's user avatar
  • 2,209
2 votes

Stop forms creating duplicate entries

Elsewhere, I'm told that a simple method to achieve this is simple JavaScript to, on-click, mark the button as disabled. That appears to potentially do the trick.
jamescridland's user avatar
1 vote

Backend method to changing base wordpress domain to prevent redirect

WordPress configuration has a "Site URL" that it uses to redirect to alternate domains to the main domain. You just need to change the site URL. The easiest way to do this is to point both domains ...
Stephen Ostermiller's user avatar
1 vote

Can I use the Laravel Database Framework without using all of Laravel?

You may use illuminate/database by requiring it in your composer project. composer require illuminate/database Basic usage Create database connection use Illuminate\Database\Capsule\Manager as ...
Yvan's user avatar
  • 111
1 vote
Accepted

What Should be the ideal sequence to Learn Programming languages to become professional developer

C++ is a programming language, even if it isn't commonly used in Web development ;) Building a Web site generally involves two parts - the server side (aka the back end), and the client side (the ...
FKEinternet's user avatar
1 vote

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

The first step will be to check the server to see what is utilising the most system resources by way of memory and CPU cycles. A MySQL database server depending on the number of connections can drain ...
Chris Rutherfurd's user avatar
1 vote

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

You shouldn't really receive requests to delete personal data if you are following good practices in safeguarding people's data and not storing data longer than you need to. There is no law within ...
Simon Hayter's user avatar
  • 32.9k
1 vote

Title Tag and Meta Description

The mere fact that your text comes from a database would not affect SEO. Google uses bots / web spiders to crawl the internet, and they basically work like your web browser. If you see the title and ...
Chris's user avatar
  • 121
1 vote

Manually insert text into existing MediaWiki table row?

As you see MediaWiki does not store the page content within table page, only the details of the page exist within that table. You need to locate the table 'text' and find the relevant row, thn use ...
Simon Hayter's user avatar
  • 32.9k

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