# mysql

  • PHP _ 2013-06-17

    Importing huge MySQL dump under Windows.

    I just received a 250MB dump of a database and I needed to see what is it inside. As you may guess, PHPMyAdmin is not a good option in this case. I decided to use the command line.

    → Read more

  • PHP _ 2012-02-12

    MySQL vs JSON file data storing

    I'm not exactly a performance perfectionist, but currently I'm working on a tool which will be used in a large system. It will deliver texts to a multi-language environment and there will be several sites/apps which will performe big amount of request to it. It is the right moment for me to choose how to speed up my code and the work of the tool overall.

    → Read more

  • PHP _ 2010-09-04

    Export mysql data to SQL script or CSV

    Yesterday I received host name, user name and password for a MySQL server. I needed to export the data from it. I didn't have access to PHPMyAdmin, I tried to connect to the server by mysql.exe on my PC, but it didn't work. And then I found really good solution - PHPMyAdmin in only one php file. I launched it from my localhost and it works. So if you need to export data or just see it, use Adminer. I also uploaded the file on my server, you can download it from here.

    → Read more

If this place saved you a few hours of debugging - or at least one existential crisis - you can buy me a coffee or check out my book Pocket Guide to Seniority. I've also written other books and built a video course called Do You Speak JavaScript? - where we lovingly dissect the strange parts of JS we pretend to understand.

RSS _ Stats _ Keywords _ License