11

Here are more organized queries against the INFORMATION_SCHEMA Sizes By Storage Engine SELECT IFNULL(B.engine,'Total') "Storage Engine", CONCAT(LPAD(REPLACE(FORMAT(B.DSize/POWER(1024,pw),3),',',''),17,' '),' ', SUBSTR(' KMGTP',pw+1,1),'B') "Data Size", CONCAT(LPAD(REPLACE( FORMAT(B.ISize/POWER(1024,pw),3),',',''),17,' '),' ', SUBSTR(' KMGTP',pw+1,1),'B') "...


6

Wikipedia probably counts as having a "huge website", even if it's still tiny compared to, say, Google. You can find a description of their server architecture here. Basically, their SQL backend consists of a bunch of clusters, each one consisting of a single MySQL master server whose data is replicated to a bunch of read-only slave servers. Also, images ...


5

There are many IP to Location databases/services there, but going for free will cost in limited number of API calls, and features (paid one gives comparatively more). Freeness of service and the accuracy of service is inversely proportional to each other. Listed below are some services arranged by accurate (or more feature) to free: MaxMind Offers features ...


5

A database-driven site doesn't necessarily have to have only a single URL or be entirely search-based. Most sites on the web today (including SE) are database-driven, but they still have different pages with individual URLs. And even search-based sites can be made to be search-engine-friendly. Your site should have a RESTful architecture wherever possible. ...


5

Note that having this sort of sub-federal jurisdiction above the level of a municipality happens in many countries, not just in the US (e.g Australia, Canada, China, India, Mexico...) To answer your question, you (modiX) need to understand why one would ask for the state (or province or territory). There are two primary reasons: If you need to use old-...


5

It's not necessarily a bad idea, assuming DB server/node/gear/droplet/etc is in the same "cloud" and stays on internal bogon routes. A couple cons that could come into play though, depending on the remote-ness are: Speed, as in round trip time to contact DB and get a reply back to the app. Caching, as in how and where will the cache be maintained Complexity,...


4

20,000 records is not a lot at all. It's not uncommon for a table to have millions of records and, if your database is designed properly, still be very fast. So using Autocomplete with a table of 20,000 or even one million records is definitely feasible and shouldn't be slow. If it is you need to revisit your database design and SQL queries to make sure ...


4

SUGGESTION #1 If you do any backups of MySQL Instance it is best to setup MySQL Replicaton so that any impose server load or increase disk I/O does not impact your production database is any way. Once you setup MySQL Replication, you can script a mysqldump in different ways (Please see my post on the DBA StackExchange for the variety of techniques), as ...


4

Yes it is possible. Once you know the Host, Username and Password for your MySQL account, you can just log in to it as you normally would from as many hosts as you want. I once did it with two different hosts. My website was on one host, and from other host I was running some cron jobs that were running queries on the other site. Although depending on ...


4

I finally found the easy way to get this information directly from Amazon with a couple of clicks. Log into the RDS management dashboard Click on "DB Instances" Click on the instance in which you are interested. That should expand it and show much more info about it. View the "Monitoring" tab on the left (it should selected by default) There is a "Storage" ...


4

There are fringe cases where zip codes can actually cross state lines. Amazingly stupid, but true: https://en.wikipedia.org/wiki/ZIP_code#By_geography Following trends blindly might be bad UI design but bucking them without a healthy dose of paranoia is a bad idea too.


4

Morgan Lewis is a law firm with offices in the UK and they have published information (as of 2012 which is the most recent authoritative publication I can find on the subject) on the ICO's guidance on deleting personal data under the DPA 1998. According to their legal assessment of the guidance the ICO recognized the difficulty in deleting electronic data ...


4

You do not say what the .sql file is for, however, a .sql file, in of itself, is just plain ol' text and therefore not a threat. Ignore it the notice. It is not uncommon that anti-virus software will hit on various files. They are looking for patterns. Known JavaScript files are often pinged as a virus. That said, if you do not know what the file is or if ...


3

MySQL is free, well documented and supported, and absolutely scalable for any reasonably-sized business need. It is a secure, mature system. If this is going to be your first real-life application with a database, I'd start with that one. There's no point in choosing Oracle or any paid option for a small mobile repair website — unless, of course, you ...


3

Yes, it's possible, both mysql (mysql_connect) and mysqli allow you to specify a host for the connection. However, I suspect you can only check by trying: some hosting services might simply block outgoing connections using a firewall, which may be outside the web host machine and undetectable until you attempt to establish the connection. If you're ...


3

Update your phpMyAdmin. The latest version (3.5) has exactly what you describe.


3

You can try dailychanges.com, it does provide a list of domain names on a certain day. However Dailychanges doesn't give access to a relevant search form, so you have to manually type the following url pattern : site:http://www.dailychanges.com/{web hosting company}/{YYYY-MM-DD} For example if you want domain names registered on March 05, 2011 and hosted ...


3

You have to read each company's Terms of Use, or contact each company directly. Nobody can determine the legality of republishing content based upon the information you've given.


3

You have to configure PHPMyAdmin to connect to the MySQL database first. If you go to http://wiki.phpmyadmin.net/pma/Config you'll see that you need to add the following example to your config.inc.php file: $cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname $cfg['Servers'][$i]['port'] = ''; // MySQL port (leave blank for 3306) $cfg['Servers'][$...


3

You need a Disclaimer - make the users to agree and understand that although you will not misuse their data, but you will not be responsible for anything that may happen to the information that they submitted voluntary. About "making the data safe", it can't be answered in this question, it's too broad and you need to be more specific.


3

Disclaimer or Terms and Conditions All sites that obtain personal information should use some kind of disclaimer or terms of conditions on submitting such data to the system, this varies from site to site and you should do a little research on what things you should be mentioning. If its for a big project then I suggest a legal adviser. It's important to ...


3

According to the Data Protection Act 1998 they do. The exceptions are data used for national security, the detection of crime, and taxation purposes. Edit: The referenced Principle 6 actually doesn't cover the removal of data on the subject's request. However, this contingency is addressed in the Conditions for Processing, as in: Consent must also be ...


3

I found the issue was the user for that cPanel account actually had an identical password to my WHM account and this threw an error (though user names were different). I changed it and it was ok.


3

You can export the database information as many text formats like CSV, JSON, TXT, SQL, etc. But usually databases are more complex than just the information contained there, for instance, there may be dependencies between tables, autoincrement fields, foerign key restrictions, etc. If you just edit the exported text, you may be breaking some of the ...


3

If MySQL servers we open to the general public like your website it would open them up to brute force attacks, and other remote attacks by bots mostly which they simply don't need to deal with. Most people who know enough that they'll need remote MySQL access should be familiar with setting that up in cPanel etc. It's a matter of security for you, and less ...


3

whois is a very poorly defined protocol (or more precisely: defined well enough at the moment it went into use, but now clearly outdated and missing key elements needed today, like tiered access and formatted output), with only RFC 3912 covering it (obsoleting RFC 954), which says mostly nothing: you send a query on one line, the server replies with a blob ...


3

No, it's not good practice to create a database user for every site user. The way you have things setup now is pretty standard. It shouldn't be possible for people to get access to passwords stored in your PHP code unless your server is compromised, and that's pretty much the worst case scenario. The only caveat is that if you are using some form of source ...


3

There's no reason that this has to be one way or the other. I would say to optimize both. If you have a large number of images, a CDN makes sense, regardless of what you do on the server. Also, even if that takes care of the problem, better database performance is helpful in general, so I would recommend tackling both options. I really do love AWS tools. ...


2

I realise this is an old post, but others with the same problem might find the solution useful. After spending ages with various fixes to session.inc.php I finally had a eureka moment and thought to check the PHP session save directory was correct and writeable. Setting NTFS permissions to Everyone on the folder has fixed it for me.. Doh.


Only top voted, non community-wiki answers of a minimum length are eligible