Questions tagged [database]
System that handles large amounts of data in an organised fashion.
156 questions
0
votes
0
answers
12
views
Moved XenForo to VPS, but it redirects to the old domain
I hope you're all doing well. I'm facing an issue that I've been unable to resolve on my own.
Here's my situation:
I have a XenForo 2.3.7 site hosted on a shared plan with Hostinger. I recently ...
0
votes
0
answers
132
views
It doesn't show up even though I add Featured Image in Wordpress
About 10 days ago, I changed my hosting company and I asked the hosting company I just switched to to move my site's files to their own servers. And then the transition was made, my website was ...
- 21
4
votes
1
answer
427
views
Import Canonical URL for YOAST SEO using Database
Is there anyway to upload (import) a Canonical URL for YOAST SEO using Database (inject bulk method)? I'm quite confused as which table and field it used for the data in the database that use for ...
- 253
1
vote
1
answer
103
views
Hosting company blocks remote access to database. How to deal?
I used a shared windows hosting for one of my customers. The hosting company does not provide remote access to databases (e.g connecting through Microsoft Sql management studio). How do you work with ...
- 291
1
vote
0
answers
28
views
What are free services available for creating MySQL on cloud? [closed]
I am new to web development. My team is planning to create a dynamic website as a project. I want to have a relational database ( MySQL) but all tutorials seem to use MySQL and PHP locally. We want to ...
- 11
0
votes
1
answer
35
views
Dynamic PHP Pages [closed]
I'm trying to make a database of herbs with their many uses. Instead of making an individual page for every single one of them, I would like to just put the info in MySQL and call it to their ...
4
votes
1
answer
2k
views
Headless CMS – why is it better than a simple database connection?
Ok, I read plenty of articles on headless/decoupled CMS systems, however I can't wrap my head around how it should be better than a simple database connection.
From what I got so far, the main ...
- 41
1
vote
0
answers
481
views
Cheapest way to use a MySql Database on Microsoft Azure
I am currently evaluating features of Microsoft Azure, and want to try their Azure Database for MySQL service in a little test project. I just need a very basic database with minimal performance and ...
- 188
1
vote
2
answers
937
views
htaccess url rewriting 2 get values
I am using PHP 7.2 URL Rewrite Rules. i am making 2 links first link is "category.php?inventory_id=" and second links "show-subcategories.php?cat_id" but the result is always the first link is working ...
- 11
1
vote
2
answers
157
views
Backend method to changing base wordpress domain to prevent redirect
My friend has come to me today to tell me he wants his wordpress site moved from example.com to example2.com.
I have full access to the same server managing both those URLs, I copied the entire file ...
- 13.7k
1
vote
0
answers
45
views
Can dbadmin be secured under nginx by using a rewrite rule to a 404?
I'm trying to redirect all 404 pages to a custom handler with NGINX.
I spent few hours to made the following rewrite in nginx but my question is: can it be a security breach?
location ~ ^/(?!(dbadmin)...
- 11
1
vote
0
answers
157
views
how to handle email signup when the same email is pending approval
How do i handle multiple signups with the same email, while email confirmation is still pending?
Here are my tables
user
uid - bigint primary key
uname - varchar 255 unique
uemail - varchar ...
- 211
1
vote
2
answers
2k
views
Can I use the Laravel Database Framework without using all of Laravel?
I work at a company with a custom PHP framework we have built over the years. For the most our custom framework suits our needs and includes almost everything Laravel offers, however, our database ...
- 111
3
votes
5
answers
94
views
Moving website images to remote server vs moving database to remote server
I have a wordpress website that has gotten too big for a single server. I need to decide whether I should host the database externally i.e. purchase another server for the DB or if i should host the ...
- 867
10
votes
3
answers
2k
views
Deleting backups - Request to delete customer data - Data Protection Act 1998
It was brought up today about the customers right to have their data deleted and went on to an interesting talk about backed up data (we have a rolling 93 day window for backups on AWS s3)
I was ...
- 203
9
votes
4
answers
17k
views
Does Amazon's RDS Multi-AZ deployment cost twice as much as the normal cost of a single instance?
It's not totally clear based on Amazon's provided documentation. Intuitively, it feels like it'd cost twice as much as a normal RDS instance for a two-zone deployment; does anyone here have experience ...
- 192
1
vote
0
answers
26
views
Troubleshooting database connection [closed]
I got problem with my website database, as you can see in the attached image below. Unfortunately My Dev and I have no idea what's going on. I think this trouble occurred after WP installation.. For ...
- 11
1
vote
2
answers
4k
views
What are the pros/cons of using remote DB
As the question says, I want to know if is good or bad idea to use a remote database, and what pros and cons does this practice have.
- 135
2
votes
1
answer
51
views
Is it possible to recover the content of a website no more available?
Some years ago I charged some information and pictures on a web platform which let companies and freelancers keeping in touch for professional purposes.
In the meanwhile the website stopped working. ...
- 823
2
votes
3
answers
2k
views
Is there any downside to using dokuwiki considering it does not use database?
I'm planing to use dokuwiki for my website but my friend told me since dokuwiki don't use database and store the data in plain text files it will put lots of strain on my host as my website grows and ...
- 21
1
vote
1
answer
340
views
homepage keeps on redirecting to install.php
I don't really have any clue what's causing this. It happened 3 times today already. The site that I'm assigned to work on keeps redirecting to http://atenews.ph/wp-admin/install.php
and when I tried ...
- 21
1
vote
3
answers
70
views
Should I ask for the state in a registration form for new clients who live in the USA?
Basically, on almost every international site, they ask for the united state you live in, once you selected that you live in the USA. Right now I'm programming a registration form for an Austria ...
- 431
1
vote
1
answer
48
views
Should I use SQL to save time? and How? [closed]
I created some landing page template in which I test various products.
currently it is a .php file which I manually change each time, along with 3 other files, plus an image, and then upload all of ...
- 39
0
votes
2
answers
130
views
Duplicate Content Database driven Website
I have a listing based website similar to yelp. We have different pages for a listing for example basic information, photos, reviews, google map address etc. Now most content on this page is similar. ...
- 163
1
vote
1
answer
337
views
How do I upgrade a seven year old version of MediaWiki to the current version and migrate from MySql to SQlite?
currently I have this:
Old Mediawiki 1.11.0 (from 2007!) on shared webhosting (so no shell access) with about 200 articles and many thousand spam articles I deleted via the Webinterface (but they are ...
- 21