System that handles large amounts of data in an organised fashion.

learn more… | top users | synonyms

1
vote
1answer
21 views

phpMyAdmin can't fint 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 ...
1
vote
2answers
29 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.
3
votes
1answer
23 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. ...
1
vote
2answers
28 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. ...
0
votes
3answers
36 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 ...
6
votes
5answers
1k views

Accept Credit Cards / PayPal on Website for Delayed Processing

I'm trying to setup a basic system on my site to accept credit cards for delayed processing. What I will be doing is collecting a bunch of orders/credit cards for a group of people, then after a ...
1
vote
1answer
220 views

Does an 'external product code' field exist in Prestashop?

I'm exporting products data from our enterprise Erp to a Prestashop installation. Our ERP products code are alphanumerics like A001, A002, etc. I would like to use this code into Prestashop, but if ...
2
votes
1answer
38 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 ...
1
vote
2answers
65 views

How to implement a software trial request form?

On my company's website I want to have a form where a visitor can provide an email address and pass an anti-bot challenge. The server would then email a trial key to the visitor. Background: I am ...
1
vote
3answers
47 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 ...
3
votes
1answer
92 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 ...
1
vote
4answers
5k views

MySQL Online Database

Can anyone suggest a good online free MySQL database. I've tried four till now: db4free FreeMySQL onPhP 000webhost Either of them gave me an timeout error on my connect file or actively restricted ...
1
vote
1answer
66 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 ...
1
vote
3answers
33 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 ...
0
votes
0answers
28 views

Virtualmin - Granting *Create database* permissions through command line

I have a script calling the remote API (which calls the command line API) of Virtualmin to execute 'clone-domains' with a --newuser and a --newpass. That creates a user that can access the cloned ...
3
votes
2answers
106 views

Moving big database from one server to another

I have created a website that I know that its database size will increase rapidly. It will become terabytes and by the way I don't want to get a expensive server at first. What is I'm concerned about: ...
37
votes
6answers
4k views

Why aren't we supposed to use <table> in a design?

What are some clear and logical reasons for why we shouldn't be designing websites with tables? Where are the benefits, what has been driving this idea in the industry? When is it okay to use a table? ...
1
vote
1answer
34 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 ...
1
vote
1answer
127 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, ...
0
votes
2answers
85 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. ...
0
votes
1answer
174 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 ...
1
vote
1answer
97 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 ...
1
vote
2answers
103 views

Should I learn html/css before php even for using database? [closed]

I have seen lots of questions about this topic and all of them were asking whether someone, who wants to use PHP for "building web pages", should learn HTML first, or not? Most of the answers said ...
0
votes
1answer
57 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 ...
1
vote
1answer
40 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. ...
2
votes
1answer
84 views

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

The WHOIS query and response protocol is widely used for databases holding various Internet resources like IPv4 assignments, IPv6 assignments, AS numbers and RIR (for example ARIN in USA or RIPE in ...
2
votes
4answers
84 views

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

In order to connect to a MySQL database, you typically use the following command: mysql -h host_address database_name -u db_user -p where db_user is associated with the database in question. ...
3
votes
3answers
52 views

Web user authentication methods

Is there any method besides using a DB with username and password for authenticating a user?
1
vote
1answer
908 views

Virtualmin cannot connect to MySQL database

I have a VPS running Webmin/Virtualmin. I host multiple domains, one of which is a Drupal 7 website that uses a MySQL database. Yesterday I went to 'Manage' the database and found that I recieved the ...
-1
votes
1answer
34 views

simple database edit webpage recommendations [closed]

It's been a long time since I've made something like this, I'm just wondering if I'm not re-inventing the wheel. My client currently has a bunch of data in an excel file and wants this to be on the ...
0
votes
1answer
380 views

How to do SEO for database driven web? Asp.net [duplicate]

Hi to everyone and thanks in advance for your time reading this question. Im kinda new on this SEO stuff and there is something that I can't figure out how it works despite all the readings that I ...
0
votes
1answer
27 views

Server Processes: Websites with and without database [closed]

I am on shared server and I have some limitations at "simultaneous processes". I have two websites: one which uses database and other without database (it's only HTML). Both are hosted on the same ...
5
votes
3answers
3k views

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

I have a MySQL database for my website hosted on Amazon AWS using RDS. It has 5GB of storage available to it. How can I tell how big the data in it actually is (and therefore how much of the 5GB ...
3
votes
3answers
146 views

Help with a CMS for content only not display [duplicate]

Hello I'm trying to make some kind of tool for an school website, what I need to do is to make students take a test and according to what are the results (27 posibilities) they get a set of activities ...
2
votes
2answers
683 views

Is there anyway i can create an intranet request form and have it be stored in a database? [closed]

I am trying to create a form for my companies intraNet site. The idea is as follows: An employee wants to make a purchase, so they will go to the appropriate page in the intraNet They will fill out ...
1
vote
4answers
77 views

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

I have two questions concerning CMS's that I need answered if possible: I need to create a site with a Database. This site will in due time have lots of traffic and many users if things go as ...
2
votes
2answers
309 views

How do yelp and google business collect information about businesses?

Do they work with some governmental sources ? Do they only use the information sent by business owners themselves ? Do they scrap the web to collect these information ? Do they have employees that ...
0
votes
1answer
7k views

List of websites/domain name that's registered daily [closed]

I want to know if there is a website that can provide me a list of domain names that is registered on a certain date. For example today or last week thursday? Does that website which can provide me ...
0
votes
1answer
43 views

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

I'm wondering what method I should use for copying data from one table to another one. I'm letting users post data through a form which uses table1 to save data. Now for displaying results I use data ...
1
vote
1answer
258 views

WordPress page title repeated in SOME pages

I have created a Wordpress site and titles were working just fine. Then, some time and plugins installed later, I noticed that in SOME pages I get the title repeated 2 times. Example of wrong page ...
0
votes
1answer
51 views

How does stackexchange websites manage to have google see multiple questions as multiple webpages?

I'm not a web developer and I had some basic experiences of web developing (I made my own website some time ago, played around with php, css, some asp.net and other pretty straightforward stuff) but ...
1
vote
1answer
67 views

Changing mysql query_cache_limit without having root priviledges

Can query_cache_limit in mysql 5 be set locally for a specific database? I don't have root privileges to change the global variable. Can query_cache_limit be set locally for each database?
0
votes
1answer
152 views

Error while importing .sql file in phpMyAdmin

Getting error while importing .sql file in phpMyAdmin please help. Error SQL query: CREATE TABLE `sbbleads_admin` ( `sb_id` BIGINT( 20 ) NOT NULL AUTO_INCREMENT , `sb_admin_name` VARCHAR( 255 ) ...
1
vote
3answers
99 views

How to download database of wordpress from another server?

I am writing a script to take backup of WordPress database through another server If I know ftp and wordpress login details, then how can I download wordpress database from another server. This is ...
0
votes
1answer
130 views

How to determine if someone is accessing our database remotely?

I own a content publishing website developed using CakePHP(tm) v 2.1.2 and 5.1.63 MySQL. It was developed by a freelance developer who kept remote access to the database which I wasn’t aware of. One ...
0
votes
2answers
95 views

Does loading metas from database affect my website SEO?

I am developing a website which is fully dynamic. If I load metas and other information of the website from database, will it affect my website's SEO?
1
vote
4answers
580 views

Is it possible to have a better sql editor for phpMyAdmin? [closed]

I am studying database systems and using MySQL and phpMyAdmin. The editor that comes with phpMyAdmin is plain editor that does not highlight any special syntax like for example: gEdit in ubuntu. Can ...
2
votes
3answers
199 views

Database Management System do exist? [closed]

I want to build a database for my no-profit association, and i was planning to do it by myself. But then i realize that really i don't have the time to buid a solid, secure system. So i was ...
1
vote
4answers
82 views

Is it possible to represent MySQL database as text files?

I find manually editing MySQL databases tedious. If the whole database was optionally represented as text files (as per Unix "everything is a file") for quick manually edits, searching and replacing ...
1
vote
1answer
158 views

How should I create URLs for database generated content that can be indexed by search engines? [duplicate]

I have learned how to retrieve data from a database to a single page by using a form, so I would not need to create many pages to show the elements of a catalog. The concern that I have is how to make ...