Questions tagged [database]
System that handles large amounts of data in an organised fashion.
155
questions
0
votes
0
answers
23
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
1
vote
1
answer
24
views
How can you generate a sysid with PHP? [closed]
I worked with ServiceNow for many years. They have a very interesting database.
Every record in the entire database has a field called the said. This number combined with a table name makes that ...
- 15
4
votes
1
answer
190
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
39
views
Stop forms creating duplicate entries
So, I've a website that, once you're logged-in, uses a form to let you post a thing. (I'm using PHP/MySQL under the hood, but it's not that important here).
The trouble is that when they post the ...
- 173
1
vote
1
answer
47
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 ...
- 319
0
votes
1
answer
24
views
Tell wordpress to save and organize images into folders?
wordpress
Is there a way to tell wordpress to sort our images and data in folders...
So for example I am creating a bunch of posts about cars and is it not nice to have wordpress store those images ...
- 61
1
vote
0
answers
21
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
1
vote
0
answers
224
views
#1044 - Access denied for user 'cpses001'@'localhost' to database 'test_db'
I have purchase i hosting with cpanel in godaddy and I am migrating a WordPress site, but the problem when I am trying to import database it gave me this error #1044 - Access denied for user 'cpses001'...
- 111
0
votes
1
answer
28
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 ...
1
vote
0
answers
22
views
In DHIS2, what is the highest number of data element that a numerator can contain to make up an indicator?
Recently, we updated the family planning dataset to collect data on 6 different age groups by clients prefered methods across all family planning acceptors (both new and continuing). So in calculating ...
- 11
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
2
answers
647
views
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?
This is the first time this has happened to me. I'm attaching the screenshot of the message I got about the threat. Also here is the link that ESET software shows me for more info about this.
I ran ...
- 115
1
vote
0
answers
382
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
0
answers
10
views
Storing session data between servers (and noob guidance) [closed]
First post here, I'm sure this information is somewhere on the web, but the problem is I'm such a noob I don't know what to search for.
So, my problem is that I want to design a sign up API. Let's ...
- 111
0
votes
1
answer
389
views
How to use a git repository to version control a whole website including databases that are made with phpmyadmin? [closed]
In the past I didn't use git and just created my web-projects local on my computer using XAMPP. By that I could create databases via phpmyadmin and simply save my other website files in the htdocs-...
- 103
1
vote
2
answers
728
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
2
votes
0
answers
49
views
Company / Product Info Directory Website - Copyright Laws
I want to create a large business directory website , which would allow a user (buyer) to search, filter and identify suitable products.
I would require company logos and use of product names (TM,...
- 21
1
vote
2
answers
42
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.6k
3
votes
1
answer
261
views
Using mySql database data directly into generating articles for my website? (newbie, needs to know where to start))
Hi all I am fairly new to web development, I've made a couple of my own sites over the years with simple html tables and free webhosts.
This time, I have decided to try to host my own site using WAMP ...
- 143
1
vote
0
answers
38
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
0
votes
1
answer
1k
views
phpmyadmin Error on GoDaddy shared hosting - Script timeout passed, if you want to finish import, please resubmit the same file
I have a database named A. I want to export it, and import it to a new database B.
I exported the A, no issues. While trying to import to the new database B, I faced the following error:
Script ...
- 504
1
vote
0
answers
155
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
0
answers
426
views
XAMPP phpMyAdmin - different users access same MySQL database [closed]
I have created a MySQL database on MyPHPAdmin (XAMPP 3.2). This is for a group project and I need to have different users access the same database.
If they have XAMPP installed on their computer, is ...
- 11
1
vote
2
answers
1k
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
0
votes
1
answer
462
views
What Should be the ideal sequence to Learn Programming languages to become professional developer [closed]
I am new in programming i haven't learn any programming language yet.
i have some basic knowledge of HTML and CSS and C++ can you please suggest me which language should be master in , to become a ...
3
votes
5
answers
84
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
2
votes
0
answers
200
views
Sentora database dump works when run from command line, but not from cron
The Setup
I'm running a webserver with CentOS 7.1 x64, Sentora, and suhosin module preinstalled.
I need to trigger a PHP script which does this (among other things)
echo exec('mysqldump -u'.USER.' ...
- 193
10
votes
3
answers
1k
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
0
votes
1
answer
47
views
Title Tag and Meta Description [duplicate]
Question is, if my title tag and meta description is getting some of content or text from DB how would this effect SEO?
e.g.
Isuzu D-Max 4x2 LS MT - Specs, Specification and Price List
Where "Isuzu ...
6
votes
3
answers
11k
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 ...
- 162
0
votes
1
answer
223
views
Manually insert text into existing MediaWiki table row?
I'm trying to update a page for a MediaWiki database running MW version 1.26.4. The MediaWiki is currenty suffering unexplained Internal Server Errors, so I am trying to perform an end-around by ...
user40589
1
vote
0
answers
23
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
2
votes
1
answer
2k
views
phpMyAdmin can't find tmp directory
I have a site hosted with BlueHost. I need to upload a rather large SQL file to the tmp directory so I can run an import.
However, phpMyAdmin is giving me the following error:
The directory you ...
- 369
1
vote
2
answers
3k
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
4
votes
2
answers
1k
views
Unable to export Magento database using Xampp PhpMyAdmin due to too many input fields that exceed PHP max_input_vars
While exporting Magento database from xampp (using PhpMyAdmin).I am getting error .sql file. and also getting a warning message during export start.
Warning: a form on this page has more than 1000 ...
- 143
2
votes
1
answer
37
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
0
votes
3
answers
830
views
Allow Link access to only one database
I have a hosting account where we have multiple domains hosted and many of them have their own database.
Coming to question, Can I share access to particular database on phpmyadmin to a person who ...
- 111
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 ...
- 23
3
votes
1
answer
141
views
How to secure database access
I am developing a personal web-site with a lot of relatively sensitive (genealogical) information stored in a MySQL database. The site engine is written in PHP. So far (prototype phase) I have only ...
- 227
1
vote
1
answer
336
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
2
answers
47
views
Wordpress DataBase Local Content different from Remote Content
Problem Description
I am developing a project using Wordpress as a CMS for a web page of a Scientific Research Group to Publish Information, News, Publications and Projects of the Scientific Group.
...
1
vote
3
answers
50
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 ...
- 401
2
votes
1
answer
49
views
Migrate URLs with old primary keys to new primary keys
We have a database which we obtained via a crawling, where every row contains a primary key X, and an unique number Y obtained from the crawling procedure (the primary key of the original source). For ...
- 121
1
vote
1
answer
41
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
1
vote
1
answer
4k
views
How do I recover WordPress page content from MySQL database?
I have a WordPress site and the database has become corrupted (long story), and it's not backed up. My plan is to create a new WordPress site from scratch and copy all the theme files, images, etc......
- 603
0
votes
2
answers
102
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
0
votes
1
answer
980
views
How to Safely Share Access with Freelance web developers
I have a running website developed in Magento CMS and hosted in AWS EC2. I just recently hired a freelance web developer located overseas to revamp my website (design, features,etc).
I have no ...
- 45
1
vote
1
answer
276
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
0
votes
1
answer
135
views
Creating mysql db error
I am trying to run DVWA in my website hosting but i have a problem:
This application at fist time needs to create mysql databases and it needs just click on a button but in my case it can't and ...
- 3
1
vote
1
answer
107
views
How to change the directory in which MediaWiki is installed after upgrading a temporary directory?
I have a section in my website which uses MediaWiki. eg. sitename.com/codewiki/
It has been 3 years since I installed MediaWiki. Now i am getting errors so i wanted to upgrade to the latest version.
...
- 735