MySQL is an open-source, relational database management system.
2
votes
1answer
913 views
When I am root, “mysql” connects without a password, even though I've set one [closed]
When I am root, "mysql" connects without a password, even though I've set one:
# mysqladmin -u root password 'whatever'
# mysql -u root -p
Enter password: (typing the 'whatever' above)
Welcome to the ...
2
votes
2answers
209 views
how do i choose a web host with support for mysqli extension in php? [duplicate]
Possible Duplicate:
How to find web hosting that meets my requirements?
I have designed a website running in php and mysql. And I used mysqli extension instead of the normal mysql extension ...
1
vote
1answer
84 views
MySQL server with website hosting with managed hosting [duplicate]
Possible Duplicate:
How to find web hosting that meets my requirements?
I work for a small business, and I am the "IT Department". I also happen to be a summer intern, so after I leave the ...
2
votes
2answers
143 views
Photoblogging engine using PHP and MySQL or PostgreSQL
I am looking for nice looking and with good usability photo blogging software to run on my server. So far I have found PixelPost, Cheesecake and EZPX.
PixelPost - look quite abandoned project
...
1
vote
1answer
202 views
PHP - How to Backup and Move Wordpress Blog Website to different directory on the same host
I setup a blog for development purposes on the *.com/a/ directory and now want to move it to the root directory *.com on the same host.
How do I Backup and Move the Wordpress Blog Website to the ...
4
votes
2answers
2k views
best way to import 500MB csv file into mysql database?
I have a 500MB csv file that needs to be imported into my mysql database.
I've made a php file where i can upload the csv file and it analyses the fields n stuff and does the actual importing. but it ...
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 ...
3
votes
2answers
2k views
self hosted open source document management apps?
I'm looking an open source self hosted PHP and MySQL document management apps.
security: accessing a document by specific users
Work flow: by admin approval (may be two admins)
document ...
4
votes
3answers
710 views
phpMyAdmin: Remove Table Drop and Empty Controls
I'm not sure this is the place to post this as there are very few questions tagged phpMyAdmin; I thought of stackoverflow, but it's not really programming. In any case, mods should feel free to move ...
3
votes
4answers
251 views
WordPress MySQL Performance
I have a website (www.americanbankingnews.com) that gets 40,000-50,000 page views today. It's currently sitting on a dedicated quad-core Xeon server with 8GB of ram. The site is powered by WordPress ...
2
votes
4answers
3k views
What is the best way to exclude bots from view counts?
My website is counting visitor views on certain pages. I noticed that Google and other Bots are "clicking" to my site like crazy and some of the pages get unrealistic view counts (compared to those ...
2
votes
4answers
149 views
Assuming unique user names / logins, do I also need a unique userID number in the DB?
My users will login into a website using a login of their choosing, but which I will check against the DB to ensure unicity. Given this, should I also have a unique userID in the DB? This could be ...
3
votes
9answers
714 views
How to check if person doesn't have multiple account?
I have two users in my website with the same IP. I asked them or him, idk, why does he have 2 accounts. He said that other account is owned by his roommate. His roommate uses other computer in my ...
3
votes
2answers
190 views
How can I make my web application faster in Australia when it is hosted in USA
I have www.localo.org hosted on a BlueHost server in USA but I am in Australia and it is INCREDIBLY SLOW!
I uploaded it to a Crazy Domains server in Australia and it ran flawlessly.
I don't want to ...
1
vote
3answers
83 views
What is hosting space and why is it increasing every day?
My hosting's disk space is increasing every day and I just wanted to know, why? I don't upload new files, but it still gets increased by every day. Anyone knows?
Thank you.
1
vote
2answers
3k views
Good php+mysql system for managing library of books (book catalogue/database software)
Anyone know a good web based system to manage libraries (of books)?
It's like a book catalogue/database software, but with web interface, because I want people to be able do searches / queries in the ...
0
votes
1answer
132 views
Is there any good hosting for asp.net and MySQL
I have an account with a hosting company and I have made a project in asp.net and I have used MySQL for the database but... the hosting company has not given my account enough privileges to create a ...
0
votes
3answers
306 views
Recommend hosting with fast MySQL database please [duplicate]
Possible Duplicate:
How to find web hosting that meets my requirements?
I am frustrated to no end with my current hosting provider, mediaTemple. Yes, they are flashy, and have some decent ...
2
votes
2answers
576 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. ...
1
vote
5answers
490 views
Jokes search engine / PHP based search engine on database
I'm looking for a script, functioning like the Google homepage that fetches data from a database rather than the internet.
This is not intended to be a search engine, but a repository of jokes that ...
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
votes
4answers
146 views
Hosting plans that allow more then 1 GB for mysql and easier mod_rewrites? [duplicate]
Possible Duplicate:
How to find web hosting that meets my requirements?
I'm using godaddy and am thinking of moving to another hosting company that allows easier mod_rewrites and a bigger ...
0
votes
1answer
1k views
Best free Vulnerability Scanners that check your websites PHP & MySQL code? [duplicate]
Possible Duplicate:
Best free Vulnerability Scanners that check your websites PHP & MySQL code?
I'm looking for a free vulnerability scanner to check whether my website has common ...
1
vote
1answer
133 views
How can I backup my websites files and folders and MySQL database using PHP and send them to an email address in splited 1 MB pieces?
A quick example would be very helpful.
1
vote
7answers
231 views
Things to consider while choosing a web hosting service? [duplicate]
Possible Duplicate:
How to find web hosting that meets my requirements?
Also does the country matter?
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 ...
1
vote
2answers
331 views
Why has mysql stopped working on localhost and how do I fix it? [closed]
I asked this at superuser but I'm having no joy there. I was really hoping someone could help because I'm stumped.
I use a MacBook Pro running Mac OS X 10.6.4
For a few years I have used MAMP to ...
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 ...
0
votes
4answers
498 views
Looking for a simple forum script [duplicate]
Possible Duplicate:
What Forum Software should I use?
I have a working website and I need to integrate a forum into it. The problem is, I need the forum script to use usernames and ...
8
votes
2answers
413 views
Best Free Web Statistics and Analytics Packages For Sites Using PHP & MySQL
I'm looking for a list of the best free web statistics and analytics packages for my site using PHP & MySQL?
1
vote
1answer
110 views
Any suggestion on MySQL services?
I would like to separate my production server into 2, one for running code, the other one is for DB, which is MySQL.
Is there any suggestion if I would like to subscribe a MySQL service? I have few ...
6
votes
6answers
441 views
ASP.NET, PHP, SQL Server, MySQL hosting provider for developer? [duplicate]
Possible Duplicate:
How to find web hosting that meets my requirements?
I am looking to find a web hosting provider that provides ASP.NET and PHP hosting. The purpose is pretty much just a ...
1
vote
3answers
2k views
large/huge example databases .sql files to download on the web?
Where can i find really large databases .sql files with 100's MB or a few GB text, 10.000.000 plus rows of text so I can test my sphinx search engine indexing
4
votes
1answer
509 views
Has anyone used WebFaction hosting for large traffic websites? [duplicate]
Possible Duplicate:
How to find web hosting that meets my requirements?
I'm a point where I'm needing to move a large traffic website off of MediaTemple Grid Server (it's maxing out the ...
0
votes
1answer
356 views
How to using ajax for voting script [closed]
I'm trying to set up some voting logic on my site, and have the vote result update without refreshing the site. I did some research and AJAX seems to be the way to go, but i cant find a good tutorial ...
3
votes
3answers
3k views
How to create separate users in phpmyadmin, each one can't see others databases?
I am using phpmyadmin to control mysql on my server, now i want to create some users to access this admin tool, what i want is to make each user can create databases but can't see others databases.
...
6
votes
5answers
937 views
Open Source website backup tool suggestions
I'm looking for an Open Source website backup tool. I'm more interested in Open Source so I can make changes if need be and possibly contribute to the software.
Automatic scheduled FTP backups ...
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 ...
3
votes
6answers
737 views
Dead-simple PHP/MySQL blogging tool?
I need a really simple solution to build a one-person blog on a shared host: When the user wants to create/edit a blog entry, he calls a PHP script on the server which will...
1. save the raw article ...
1
vote
3answers
283 views
Multi site wordpress setup
Currently my company has 3 blogs and what I did was to install three instances of wordpress over Apache/MySQL, in different directories. The problem is that I have a Slicehost VPS with 256Mb RAM with ...
7
votes
1answer
152 views
My shared-host tells me that they're throttling my website because of MySQL, what can I do?
My shared-host tells me that they're throttling my website because of MySQL, what can I do?
I'm not familiar enough with performance tuning of MySQL, generally MySQL just works for me. What questions ...
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 ...
