Tagged Questions
2
votes
3answers
77 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
87 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
83 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
68 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
178 views
2 Websites, 1 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.
...
0
votes
1answer
717 views
Auto-Complete Search + SQL [closed]
I'm trying to build a auto-complete search for an internal Workflow-system builded in php and SQL. Do you know were can I find any pre-builded code or any help-material?
Many thanks in advance!
3
votes
2answers
370 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 ...
0
votes
1answer
285 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
584 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
724 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
345 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
316 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
225 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
542 views
MySQL, SQLServer, Oracle, Postgree, CouchDB, MongoDB, Cassandra or SQLite? [closed]
Who database engine is better, in performance and usability?
3
votes
3answers
502 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
48 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 ...
2
votes
2answers
584 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
62 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
102 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
123 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 ...
12
votes
6answers
2k 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
2k 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 ...
