(Just in case this is an XY problem): I need to export a really big table (85M rows), I don't have SSH access. And neither PhpMyAdmin nor SQLYog (remote connecction) are working fine (they export just a 3% of my…
I've executed the copy table operation from PhpMyAdmin and it is taking too long (big table), and now the original and new table are not responding (I can browse the other tables in PhpMyAdmin) I think because maybe there is…
So I am currently learning react and webpack so that I can implement it into my current site. I already have an established phpmyadmin database that pumps out information that I want to appear on my site but I cant…
Previously I performed the migration of my database from one directory to another within the server itself (/var/lib/mysql to /mnt/mysql) for lack of space. When starting the server again, after having changed the /etc/my.cnf with the correct directory it returns…
Consider the following scenario: There are couple of entities in my Laravel application like the following: Post Page Image Video All the above entities can have CustomFieldValues, which is another entity. The structure of the custom_field_values table is as follows:…
I have a table with 2M records and everything works fine until few hours ago. suddenly it throw error on a query that previously works fine for more than 1 year. The problem is that inserting a correct dateTime like…
I have tried my best to google this issue and I think maybe I am just doing something wrong that I don't understand? I have a small PHP page that generates some JSON for me from a database for use…
I have a csv file which it has a Polish characters too. The content of this is here: ID_WORKER;FNAME;LNAME;WORKERS_GROUP;POSITION; 1;Paweł;ĄąĆćĘꣳŃńÓ󌜏źŻż;IT;IT Specialist; 6;Dawid;ĄąĆćĘꣳŃńÓ󌜏źŻż;Technologists;Technologists; 8;Maciej;ĄąĆćĘꣳŃńÓ󌜏źŻż;Storekeepers;Storekeeper; As you see it has these characters like "Ąą Ćć Ęę Łł Ńń Óó Śś Źź Żż".…
MySQL was working fine and then for no reason I start getting this error whenever I open http://localhost/phpmyadmin/ I spent hours here trying to find solutions but all what I've tried did not work. can someone please help me? I…
I'm showing MySQL table results on my page and I'm trying to highlight the rows where the Next review date is earlier than today's date, these rows should be colored red (later I would want another coloring as well, today+10…