16

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, ' '), ...


8

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. There is a "Free Storage Space" graph:


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,...


5

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

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

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

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

Amazon's RDS pricing page has two sections. One for Single-AZ Deployment and one for Multi-AZ Deployment. Yes, Multi-AZ is about twice the price of Single-AZ. For example I see: db.t2.micro single - $0.017/hour db.t2.micro multi - $0.034/hour


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. ...


3

Its difficult to give a good answer without knowing more specifics, but - Remote access to databases is usually disabled because its a security risk with limited upside. In the MySQL world it is common to provide access to PHPMyAdmin. I dont get involved with Windows much, but there are no doubt equivalent tools (eg https://sourceforge.net/projects/mammo/ -...


2

TYPE should be ENGINE CREATE TABLE `sbbleads_admin` ( `sb_id` BIGINT( 20 ) NOT NULL AUTO_INCREMENT , `sb_admin_name` VARCHAR( 255 ) DEFAULT NULL , `sb_pwd` VARCHAR( 255 ) DEFAULT NULL , PRIMARY KEY ( `sb_id` ) ) ENGINE = MYISAM ;


2

The URLs should be something like www.example.com/?id=XXX. Based on the ID parameter, you can extract the required data from your database and pass it in the response. I have learned how to retrieve data from a database to a single page by using a form I think you are using the POST method in your form, and because of that the parameters will be passed ...


2

There is no impact to SEO whether meta information is static HTML or dynamically generated HTML. By the time the search engines see it there is no difference - they look at the meta content itself and not the technology behind it. If managing the meta information in a database helps you to ensure it is kept relevant, up-to-date and accurate then obviously ...


2

Search engines bots see your final HTML (after the server delivery of your page to the client web browser). Therefore, you can build and customize your pages like you want. Otherwise, it depends on what you modify compared to the old version of your site. If you modify good SEO spots like <title>, <h1>, <h2>, etc., your SEO can be impacted ...


2

I would say it is mix of all four you mentioned. When the website is small and trying to cover only a small area, they will start by contacting business to list or even get there details and enter it themself. Later as they grow they start buying lists from companies like D&B and give the owner of the businesses to claim their business so they can keep ...


2

Short answer. Simple answer. Most websites primarily buy lists from phone companies and scrape the web. Sometimes they get lists from Chambers of Commerce registries, license registries, Post Office, associations, and so forth. As well, they can buy lists from rating companies like Dunn and Bradstreet and various lower level marketing companies which often ...


2

Sounds like you have three parts here: User and authorization management Content classification, profiling and/or authorization (possibly done by "tagging" or metadata) Content management--some CMS handle parts of the above 2 If this setup is core to your business model, consider developing your own setup, though most independent CMS professionals I've met ...


2

show table status from mydatabsename; where mydatabasename is your database name. This shows you the metrics Data_length and Index_length per table and other metrics. You would have to total these columns and remember that they are in bytes so you would have to divide by 1024 to get kb and then by 1024 again to get megs and then by 1024 again to get gigs. ...


2

Depends on the amount of data. If: No large/weird/complex queries No large datasets Rowlocking (innoDB) instead of tablelocking (MyISAM) No absurt amount of users/pagehits Then you have no problem at all. Just make sure you index the right columns, and cleanup what you can so you dont get redundent data. If you're not sure when you should consider ...


2

This sounds like you would benefit from a GUI to do this for you... However some one would need to build that for you (assuming you're not a developer). Exporting to a different format is not advisable in most cases as if your database is relational or has any constrains, then editing without having these rules enforced will likely cause issues and prevent ...


2

Have you checked that Google Spreadsheets doesn't already do what you want? It would certainly allow a spreadsheet to be edited from anywhere and by multiple users. You may also be able to use their api to extend what it is being used for.


2

I found these resources that may help. They explain the errors rather well and what to do about them. Got error: 2013: Lost connection... https://stackoverflow.com/questions/10563619/error-code-2013-lost-connection-to-mysql-server-during-query https://serverfault.com/questions/29597/what-does-mysql-error-2013-mean http://dev.mysql.com/doc/refman/5.0/en/...


2

Depending on how users access the site, you might be able to authenticate simply by their IP address. There is also HTTP authentication, both basic and digest. But if you need to differentiate between multiple users then these need to be stored somewhere, and regardless of the method used, this is a "database".


2

For what I undestood the /codewiki/ is still working with the old database, right? If so, back it up and do the upgrade process again on the live version. You already saw it's working in the /tempwiki/ so it should be fine. By taking a look at Mediawiki's Upgrade Documentation, they address the live upgrading issue this way: Can my wiki stay online while ...


2

Have you changed the URL in two places in the general settings in the dashboard? If your new test site is actually pointing to the URL of the old site it can cause unexpected results. If you can't change it in the dashboard - because this may prevent you loggin in - in the database in the wp_options table you will find two records with the URL. ...


2

Wordpress stores serialised data for the links and other essential information about wordpress, what you've done wrong in my opinion is the export of the database. I am using WP Migrate DB plugin to export database, and I've already used it for many websites without a problem, go over the process again and export your database with WP Migrate DB plugin and ...


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