2
votes
4answers
64 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. ...
1
vote
1answer
126 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
vote
2answers
42 views

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

I saw lots of question about this topic and all of them were talking if someone want to use php for "building web pages", should learn html first or not. and most of them said yes, because most of ...
2
votes
3answers
71 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 ...
1
vote
1answer
55 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
3answers
61 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 ...
1
vote
4answers
47 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
35 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 ) ...
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 ...
2
votes
3answers
4k 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
1answer
804 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 ...
1
vote
1answer
151 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 = ...
-1
votes
1answer
85 views

displaying a list of files [closed]

In my web application I have the user sign up for an account, then the account data is saved in a mysql database. The user can then go to "index.php" and log in with their credentials. My application ...
2
votes
2answers
289 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. ...
3
votes
2answers
948 views

How do I disable username prefixes on mySQL databases?

I know of the potential risks. The only "useful" thing I've been able to find after Google-ing is this, on the cPanel website, which has no context whatsoever. Does anyone know how to do this? My ...
1
vote
1answer
391 views

What database engine should I use? [closed]

I don't know if this is the right place to ask this question but I want to become a web programmer for my occupation very soon. I actually went to a store known a PC WORLD in the UK where my laptop ...
3
votes
2answers
750 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 ...
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 ...
4
votes
1answer
472 views

Performance : Auto Complete Search for a large amount of data?

I have a table(mysql) containing around 20,000 records and I am trying to build a auto complete search box for my website. Someone told me that auto-complete search for such a large number of records ...
5
votes
4answers
345 views

What database use for huge servers?

Suppose I had a HUGE website (which I don't, but let's suppose), the common MySQL on a single server wouldn't work, because the MySQL server wouldn't be able to handle thousands of requests per second ...
3
votes
4answers
318 views

Why do some hosting companies restrict the allowed characters in DB names?

GoDaddy allows nothing but letters and numbers in database names. Other hosting companies have similar restrictions. Could there be any technical motivation behind this?
1
vote
1answer
623 views

MySQL, SQLServer, Oracle, Postgree, CouchDB, MongoDB, Cassandra or SQLite? [closed]

Who database engine is better, in performance and usability?
3
votes
3answers
985 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 ...
0
votes
1answer
60 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 ...
3
votes
2answers
1k 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
64 views

Phantom activity on MySQL

This is probably just my total lack of MySQL expertise, but is it typical to see lots of phantom activity on a MySQL instance via phpMyAdmin? I have a shared hosting plan through Lithium, and when I ...
1
vote
1answer
108 views

Thoughts on this approach for a news post caching system?

I'm working on a website which uses /news/title-of-news-article--111.html (111 = unique ID of the news article). I was thinking it might be a good idea to have some form of a caching system for the ...
2
votes
3answers
132 views

Know a good place to purchase seed data of storenames, addresses, and phone numbers?

I just build a new web app, and I am looking for data to seed it with. Anyone know any good seed data retailers? Or am I missing something and there is a way to do this for free. I am entirely open to ...
13
votes
6answers
3k views

Single V/s Multiple Databases

I've built this web app (php & mysql) which stores information for various organisations (about 20 clients currently). The current scenario stores client-related information in individual ...
11
votes
7answers
3k views

Should I use mysqldump or mysqlhotcopy for MySQL database backups?

I have a WordPress blog running on a MySQL database that I want to back up regularly. Would it be better to use the mysqldump program or the mysqlhotcopy script to make backups? What are the pros and ...