Tag Info

New answers tagged

1

If it is the "world" database downloaded from here, it is in latin1 encoding. Use that for importing. UTF-8 (utf8 or utf8mb4 in MySQL) has become the de facto standard nowadays for operating systems and global comunications (except in some countries and specific areas of knowledge), and utf8 is now the default encoding in MySQL (since 5.5). latin1 was the 1 ...


2

Yes, that (1.4.4) is the latest version of the utilities as of 2014-08-20 (although the version 1.5.1 is probably going to be released very soon). Since approximately when MySQL 5.6 was released, the MySQL utilities have had an independent download from MySQL workbench (so they can be easily installed on text-only servers) and they have its own numbering ...


1

MySQL Workbench is a client querying and modelling tool and a very good one at that - it's purpose is not to perform server tasks - that's the job of the server. You can perform manual backups using Workbench, but I'm assuming that's not your long term goal. There are many ways you can perform backups. Take a look here for 10 of them. Some of the solutions ...


2

When you connect to MySQL from the command line, simply run: CREATE DATABASE mydb; What does this do ? This will create the folder /var/lib/mysql/mydb The ownership will be mysql:mysql File permissions will be set by the mysqld process Of course, you need to connect to MySQL as root@localhost Notwithstanding, I would strongly advise you to MySQL ...


2

Yes, most linux system administrators only use the command lines client (or other cli tools to work with the database). Maybe the only other thing you will need for design is a text editor (for writing easily before executing), like vi(m), nano or emacs, and pen and paper. Here it is a first crash course: Create a database: CREATE DATABASE ...


2

Management Studio is the tool you should probably be using to manage a SQL Server database. You can download SQLManagementStudio_x64_ENU.exe from here: http://www.microsoft.com/en-us/download/details.aspx?id=43351 For the C# side, you could use Visual Studio: http://www.visualstudio.com/downloads/download-visual-studio-vs#d-express-windows-desktop


0

here is a solution how I fixed this: 1) Add "mysql" database to the user, you are logged in with Advice: now you can alter functions and procedures 2) Add the global privilege "SUPER" to your user Advice: otherwise you will get the following error if you save the procedure/function: "ERROR 1227: Access denied; you need (at least one of) the SUPER ...


0

From the error message, what i can deduce is that a foreign key is trying to reference a table with a primary key of int, while it also has a primary key of int set on it's table, a bit confusing. But try removing the primary key on the referencing table like table two below, it should work fine. so you could do something like TABLE 1 ...



Top 50 recent answers are included