|
|
MySQL database:
- How to change password to the database?
- When I try to make dump of large tables from MySQL I get message "Out of memory (Needed ???? bytes)Got error: 2008: MySQL client run out of memory". What should I do?
- I already have my own MySQL database and I'd like to move it to your server. How can I do this?
- My script doesn't add information to the database from text file with command "LOAD DATA INFILE ...". Does this command have any limits?
- If you still have any quesions, Contact us.
MySQL database:
- Q: How to change password to the database?
A: You can change password to your database from Control panel. Or you can use shell. To change password type in command line:
mysqladmin -h database -u _database_name_ -p password _new_password_
("password" is a keyword, don't change it)
- Q: When I try to make dump of large tables from MySQL I get message "Out of memory (Needed ???? bytes) Got error: 2008: MySQL client run out of memory". What should I do?
"-q" to prevent using the memory.
Example:
bash$ mysqldump -q ......
- Q: I already have my own MySQL database and I'd like to move it to your server. How can I do this?
A: You should use command mysql_dump. For futher information about MySQL visit www.mysql.com.
- Q: My script does not add information to the database from text file with command "LOAD DATA INFILE ...". Does this command have any limits?
A: "Load data infile" loads a file from the host where database locates. You have no access there. You should use command "load data local infile".
Make notice that the command "load data local infile" doesn't work without the keyword --local-infile.
|
|
