[DiscordArchive] Do you mean executing an SQL-file? on Debian? A faster way?
[DiscordArchive] Do you mean executing an SQL-file? on Debian? A faster way?
Archived author: STARRHELD • Posted: 2019-07-16T20:24:59.137000+00:00
Original source
Do you mean executing an SQL-file? on Debian? A faster way?
Archived author: Racknar0 • Posted: 2019-07-16T20:27:14.008000+00:00
Original source
<@!171701405172760577>
I explain to you, and I'm sorry for my googling English
I run a sql file from my browser, even from the same console
mysql -u database XXXX-p <file.sql
And it takes too long, the world database has taken me more than 2 hours running
Archived author: STARRHELD • Posted: 2019-07-16T20:34:07.600000+00:00
Original source
What kind of setup do you have? It should not take 2 hours
Archived author: STARRHELD • Posted: 2019-07-16T20:34:18.185000+00:00
Original source
And yes, via the command is the fastest way of doing it
Archived author: Nix • Posted: 2019-07-16T20:34:47.405000+00:00
Original source
Make sure you actually run it from the command line of the host which the database is located on
Archived author: Nix • Posted: 2019-07-16T20:35:07.168000+00:00
Original source
If you run it from a remote pc trying to execute the SQL for the host, its going to take just as long as if you tried through the UI.
![[Image: unknown.png?ex=690c5ec9&is=690b0d49&hm=b...33e765880&]](https://cdn.discordapp.com/attachments/369084351129845760/600788655509864468/unknown.png?ex=690c5ec9&is=690b0d49&hm=b3c0d628023402e0e7380f2b5133e08193f65e4d70d3fbff2b8b5a333e765880&)
Archived author: Racknar0 • Posted: 2019-07-16T20:39:38.683000+00:00
Original source
![[Image: unknown.png?ex=690c5ec9&is=690b0d49&hm=b...33e765880&]](https://cdn.discordapp.com/attachments/369084351129845760/600788655509864468/unknown.png?ex=690c5ec9&is=690b0d49&hm=b3c0d628023402e0e7380f2b5133e08193f65e4d70d3fbff2b8b5a333e765880&)
Archived author: Racknar0 • Posted: 2019-07-16T20:39:56.555000+00:00
Original source
2 hours for me to throw that error hehe
Archived author: Racknar0 • Posted: 2019-07-16T20:41:01.996000+00:00
Original source
perform a clean installation, mysql 5.6 use on all my servers
Archived author: Racknar0 • Posted: 2019-07-16T20:42:11.827000+00:00
Original source
<@!171701405172760577> my setup 2 cores ando 8Gb Ram