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

learn more… | top users | synonyms

0
votes
0answers
11 views

How To Backup And Restore WP Installation And Database On Various Local Partitions? [on hold]

I am running a local development environment with WAMP on partition C and have a WordPress database there. My WordPress installation however is on partition D in a subfolder of my web projects, ...
0
votes
0answers
14 views

Database relations with php [closed]

Im wondering for a longer while, I am using phpmyadmin which is mysql. I create there a database add tables etc, but is there any reasonable reason to make relations inner phpmyadmin? since while php ...
1
vote
3answers
19 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
9 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 ...
0
votes
0answers
23 views

Importing opencart 1.5.4 database into 1.5.4.6 version

Hi when can someone give an idea how recover from an 1064 error when trying to import opencart 1.5.4 database into 1.5.6.4 version? For more info check out the attached image.
2
votes
1answer
25 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
1answer
30 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
53 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
62 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
65 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
48 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 ...
0
votes
1answer
38 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
33 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
58 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
79 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
48 views

Web user authentication methods

Is there any method besides using a DB with username and password for authenticating a user?
1
vote
1answer
639 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
205 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
24 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 ...
1
vote
2answers
80 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 ...
5
votes
3answers
975 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 ...
0
votes
1answer
38 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 ...
0
votes
1answer
50 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
4answers
70 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 ...
1
vote
1answer
63 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?
2
votes
2answers
183 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 ...
1
vote
3answers
71 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
2answers
83 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
55 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 ...
0
votes
1answer
73 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
1answer
97 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 ...
0
votes
2answers
39 views

Tracking state of a one time event on a big website

Assume a website with 250 million active users. I add a new feature to the website. Once a user visits I want to use a short tutorial to teach them how to use said feature. I only want them to ...
0
votes
1answer
72 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 ...
1
vote
1answer
233 views

Export Foxbase database tables to csv

I have no experience with Foxbase whatsoever and I'm used to working with MySQL via phpmyadmin or interfaces like that. My company has a third party database we're trying to move away from, but we ...
0
votes
1answer
79 views

Can I give access to database without access to cpanel

I'm going to give a freelancer access to the database. The idea was to give him the access with SSH (MySQL Workbench). But it came out that to do so, I would need to give him the password to my cpanel ...
3
votes
2answers
103 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: ...
1
vote
2answers
53 views

Issue when changing Joomla! 3.1 server

I am changing my Joomla server from last host to another (the domain changed to). First I made a ZIP backup with all of my instalation files (even .htaccess/php.ini/etc...), I mean, ALL files from my ...
1
vote
1answer
50 views

Is it possible to block access to a DB based on IP?

We're looking to beef up the security on a site, among other things we thought of trying to block access to the DB based on IP (in a similar way you can do a FTP lock dependent on IP), so that only ...
1
vote
1answer
41 views

Not able to see databases in symlinked folder

I created a folder on my Dropbox and then symlinked it to both of my computers that I use for development. The folder is working correctly and I can see all the files in it from both computers. The ...
1
vote
1answer
60 views

I want to combine the databases from two different sites under one URL. How is this possible?

I have a small site that I want to merge with a bigger one. Both on Wordpress. How can I merge the second one with the first? I know that one solution would be to make the smaller one a subdomain of ...
1
vote
0answers
223 views

Database for student Portal(A school website) [closed]

I am presently working on a school website, it is going to have student portal in it. Please, i need idea on how you think the database structure will look like. Its a university web, students are in ...
2
votes
3answers
6k views

Accessing PHPMyAdmin via URL (without cPanel)

I am having issues accessing PHPMyAdmin from cPanel. It will not allow me to as I am logged in a root. I cannot seem to be able to make another account for cPanel either, and research indicates this ...
1
vote
1answer
222 views

How to access phpMyAdmin with Hosting Controller?

I am trying to update a site for a client. All the login info they have given me is for something called Hosting Controller. I've never seen it before but it seems like cPanel. I can create email ...
3
votes
3answers
115 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 ...
4
votes
2answers
597 views

Am I legally required to remove all data associated with a customer (UK)?

A customer has asked that we remove all our stored information from our database. From a moral standpoint, we have no problem with this, but simply deleting all the data will leave us with orders ...
3
votes
2answers
101 views

How to safely saving users' data and NOT get responsibility of users' data?

I am programming a website which will save up users' inputs for their next visits. For example, I might save their phone numbers. The user will know that I save their phone numbers. However, do I need ...
2
votes
1answer
884 views

Trouble creating new MySQL user/database with PHPMyAdmin

I did a brand new install of PHPMyAdmin and I managed to get it set up a while ago with a single non-admin user and a database. I now want to add a new user and new database. So, I went to the ...
3
votes
2answers
159 views

Setting up a coming soon page. Should I create a whole database for “Sign up now for updates” email addresses?

I'm helping a friend set up a "Coming Soon" page for his website. Naturally, he wants people to enter their email addresses so they can get updates about the status of the website. I know I can set up ...
2
votes
2answers
47 views

Address database?

I'm not sure if this is the best place to ask this, but it goes. I'm doing planning/research for a website that NEEDS a database of addresses for every home in the US. I don't need resident names or ...