Posts by Marcony Felipe • 879 points
15 posts
-
0
votes1
answer314
viewsQ: Avoiding dump for Mysql users
For a specific Mysql user, there is a way to block it from doing the Data Export (DUMP) of a specific table, or of the entire database? I couldn’t find a solution... How you handle it? Thank you!…
-
3
votes2
answers1269
viewsQ: Parameter varchar in Store Procedure
I have a mysql store as follows: CREATE PROCEDURE nome_procedure(campo VARCHAR(15)) BEGIN SELECT id as id, campo as value FROM tabela etc etc etc...; END $$ However, since the parameter I am passing…
-
19
votes1
answer783
viewsQ: Algorithm for name generation
I did a lot of research, but I couldn’t find an algorithm that would do something like banks do. For example, when you first register in a 24-hour box, the machine will generate a password. In…
algorithmasked Marcony Felipe 879 -
4
votes2
answers392
viewsQ: Git push command with no apparent effect
A simple GIT question... I created a repository on the remote server and performed a git remote add (...), git add "files", git commit and git push origin master, on my localhost, so I could connect…
gitasked Marcony Felipe 879 -
1
votes3
answers415
viewsQ: Automatic method execution
I have an x class that needs to run a y method once a day. However, how to do this in Object-Oriented PHP? P.S.: In structured PHP, it used crontab or fcron to program that a given URL was executed…
-
6
votes1
answer1595
viewsQ: Mysql database update
I’m working with one database on the localhost and the other on production. At various times I need to update my local bank to match the server. I made a . sh script to be able to copy all the files…
mysqlasked Marcony Felipe 879 -
2
votes1
answer71
viewsQ: Safe Updates in Phpmyadmin
In Mysql Workbench has a very useful function called: "Safe Updates", which prevents Updates in a column without WHERE, for example. In Phpmyadmin, is there this function? I could not find.…
-
2
votes2
answers385
viewsA: Innodb and Myisam generating Table already exists error
Follow the solution for anyone who might have the same problem. If someone else has a more practical solution, please do not stop posting (I had tested several solutions over the Internet that did…
-
3
votes2
answers385
viewsQ: Innodb and Myisam generating Table already exists error
I am reformulating some screens of my system that, entirely, uses Myisam as Mysql Engine. In this case, these screens will use Innodb after reformulation. Excludes, by Phpmyadmin, all tables Myisam…
-
7
votes1
answer526
viewsQ: 503 redirect across multiple Urls with the exception of one
How to make a 503 redirect (maintenance code) throughout the site, but leave only one URL with access? Server: Linux (Apache) with PHP 5.5 and Mysql.
-
3
votes1
answer992
viewsQ: Refresh page in time interval
I need to set the goal: meta http-equiv="refresh" content="30" However I am using Codeigniter and I can’t do it. I tried: $this->output->set_header('refresh:30;url=minhapagina.php'); Any…
-
0
votes3
answers250
viewsQ: Ideal environment IT sector
In a reformulation of the work environment, where 10 programmers work, there is some study/article where demonstrates and explains the best layout for table layout coupled with increased…
project-managementasked Marcony Felipe 879 -
7
votes2
answers1761
viewsQ: Exchange impact - Myisam for Innodb
In a medium database (~2GB) Mysql that is all with the Myisam engine. Performing the conversion to Innodb, what will be the impact on my system? I can simply convert by phpMyAdmin, for example?…
-
2
votes1
answer307
viewsQ: UPDATE and SELECT at the same time (locked)
Monitoring the database (Mysql) through Monyog I realize that when some very large query is executed (SELECT) and, at the same time, an update query also runs, under the same table, the update is…
-
14
votes4
answers6297
viewsQ: Form inserting twice in the bank (F5)
I have a great form that update and insert at various points when submitted. However, if in the time interval of this process the user presses F5, he duplicates the insertion record the number of…