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

learn more… | top users | synonyms

1
vote
3answers
25 views

CMS with multiple of single database [on hold]

I have a couple of questions concerning CMS 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
3answers
99 views

Help with a CMS for content only not display

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 ...
1
vote
1answer
29 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?
1
vote
1answer
25 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
23 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
43 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
52 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
53 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
284 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
109 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
37 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
36 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
0answers
10 views

non-invasive database content management? [duplicate]

I work for a group that has an already existing, built-from-scratch LAMP (plus javascript) website. There are currently no content management systems in place, and up to now the method for updating ...
3
votes
3answers
852 views

Storing User-uploaded Images

What is the usual practice for handling user uploaded photos and storing them on the database and server? For a user profile image: After receiving the image file from user, rename file to ...
2
votes
3answers
2k 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 ...
2
votes
2answers
281 views

Two websites at the same host but on different accounts to use the same database

I have 2 websites and would like to use the same database for both sites. The MySQL database contains just a simple guestbook. The websites are one seperate hosting accounts, but with the same host. ...
1
vote
1answer
161 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 ...
1
vote
3answers
315 views

Should users be deleted after inactivity on a website?

When you have a social website or a website where you can register, would you eventually delete them after a certain time (after a year of inactivity) or would you rather keep their account records ...
0
votes
2answers
34 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 ...
1
vote
1answer
91 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 ...
1
vote
1answer
39 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 ...
4
votes
3answers
337 views

Can I place a directory that lists other companies contact details on my commercial website?

Can I place a directory that lists other companies contact details and other relavent information on my commercial website? We are a magazine site and this would be placed for an additional resource ...
32
votes
5answers
3k 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? ...
3
votes
2answers
905 views

MySQL vs. SQL Server GoDaddy, What is the difference between hosted DB and App_Data Db

I'm using GoDdady for site hosting, and I'm currently using MySQL, because there are less limits on size,etc. My question is what is the difference between using a hosted GoDaddy Db such as MySQL vs. ...
0
votes
1answer
48 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 ...
2
votes
2answers
495 views

CIA.gov “World FactBook” MySQL? [closed]

Is the CIA's 'World FactBook" of statistics and national data available in a MySQL format or some format conducive to parsing and incorporating into a website?
0
votes
0answers
14 views

Are there any webhosts that do not require an IP address for direct database access? [duplicate]

I am trying to create a little program with Java/JDBC and MySQL that updates a database on my website periodically. However, this is for work and I am having problems remotely connecting via JDBC to ...
3
votes
2answers
98 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
46 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
56 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
84 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 ...
0
votes
1answer
1k views

List of websites/domain name that's registered daily

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 ...
1
vote
4answers
2k 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 ...
3
votes
2answers
135 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 ...
1
vote
3answers
3k views

import.php parameter missing?

Whenever I try to delete or update any of my tables in phpMyAdmin I receive the following error: 1.import.php: Missing parameter: import_type. 2.tbl-alter.php missing parameters:field I have ...
3
votes
1answer
835 views

Search Engine Indexing of a Database-Driven Website

Suppose I have a MySQL whose rows are dog breeds and whose columns are properties of the breeds (e.g. coat color). The purpose of the site is to allow users to query the database with questions like ...
4
votes
2answers
309 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 ...
2
votes
1answer
719 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
87 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
2answers
43 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 ...
1
vote
2answers
89 views

Looking for a “database/dashboard” CMS. Any tips? [duplicate]

Possible Duplicate: Which Content Management System (CMS)/Wiki should I use? I'm looking for a CMS that can handle: User types at 3 authorization levels (client, partner, admin) a ...
0
votes
1answer
108 views

How to connect to database on remote server

Where there is VPN to remote server and then access to the database via local network interface, how can one establish a remote link between one's computer (with a programme such as Visual Studio ...
15
votes
6answers
454 views

How do you backup your websites?

I was just wondering how the community backs up their websites? I take a nightly dump the database and shift it across onto another server which then gets backed up onto removable media. It is ...
1
vote
2answers
118 views

How many pages can be uploaded in the single website without offending popular search engines?

Currently we are serving details to our visitors through a database oriented website. Visitor selects around 5 Level options E.g. Level One: book Level Two: Chapter Level Three: Topic Now ...
0
votes
1answer
26 views

Storing visitor account info? [closed]

This might sound pretty simple and dumb but I need your help here I am starting an eCommerce marketplace, I am pretty new to it so I just wanted to know when a visitor/ buyer registers on my site, ...
1
vote
1answer
145 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 ...
1
vote
3answers
2k views

Products missing from backend after import

My client imported about 70 products into magneto and the all imported properly it seemed, but now only about half of them appear in the catalog ( backend ) searching for the SKU returns no results. I ...
1
vote
1answer
121 views

get mysql_real_escape is giving me errors when I try and add security to my website [closed]

I tried doing this: @ $db = new myConnectDB(); $beerName = mysql_real_escape_string($beerName); $beerID = mysql_real_escape_string($beerID); $brewery = mysql_real_escape_string($brewery); $style = ...
3
votes
2answers
717 views

Remote database connections in mysql and php is it possible?

I need to know whether remote database connections are possible in every server? does every host provides the option for remote DB connection? and further this connection will be the second connection ...