When migrating wordpress sites, from one server/host to another… you might encounter some problems with 2 things: Absolute vs Relative paths for e.g. images Serialized data. This is how to fix both: Absolute paths: can be fixed by my previous post here Serialized Data: by modifying your absolute paths for URL’s of Image paths, your […]
Migrating wordpress sites to another host Read More »
Yes, of course you can replace a string in all fields of a specific table in a specific databases by using the REPLACE function. No, you can not easily do this on an entire database… you have to script this. I have found a Brilliant script @BrillianSheep.com which I modified a little bit for readability…
Mysql: Replacing string in all tables of a database Read More »
Wondering which tables are big in your MySQL database? Plain and simple: run the following query on your database to calculate the table size in MegaBytes (MB) for your select MySQL database: select table_name, round(((data_length + index_length) / (1024*1024)),2) as ‘size in megs’ from information_schema.tables where table_schema = ‘db_name’;
Calculate of view the MySQL Data table size Read More »