to create database on remote server

[sand123]

I have to create one database on remote server.

There is already one database.
user is for that database is: squid_xmb1

when i create another database it gives the following error..

mysql> create database documentation;
ERROR 1044: Access denied for user: 'squid_xmb1@localhost' to database 'documentation'
mysql> grant all privileges on squid_xmb1 to squid_xmb1@localhost
-> -> identified by 'password';

it gives the error...

and thru MySql Control Centre ,it gives following error

[safesquid] ERROR 1045: Access denied for user: '[e-mail]' (Using password: YES)

[tsinka]

Hi,

that's difficult. Seems like you have a (high speed, maybe flatrate) internet connection with DHCP assigned IP addresses. So your IP address/host name will change each time you dial in/get a new ip address. So it might be near to impossible to set up a user on the remote database (exception: use % as Host but that's not very secure).

Is there e.g. a phpMyAdmin available somewhere which you can use to set up the database ?

EDIT: as long as you have that specific host name try to grant the privileges to that host ([e-mail])

But you might not have the privilege to change privileges.

Thomas

[sand123]

🙂

Thru CPanel..for that server

I created new user and database.

but,can't we create users and databases thru command line..
by giving the command??

grant all privileges on database to user identified by 'password'

Thank you,

[sand123]

can we create dataonly backup thru command line(by using mysqldump)??

#mysqldump -h localhost -u user -ppassword dbase > dbbkup.sql

this command creates the whole backup.

I want only dataonly backup.

bcoz, if restore that dbase to another dbase,
it gives the error of 'table already exists'.

[tsinka]

If you want to have a backup you can restore the database if some of the tables already exsist then add the following argument to mysqldump:

--add-drop-table

That will add DROP TABLE statements to the exported data (which is in fact a list of SQL commands if you use mysqldump).

But be aware that this will drop every existing table when you try to reimport the data with mysql so make sure that the existing tables don't contain any data you still need (adding --add-drop-table will not affect or delete any tables while creating the export with mysqldump. It just adds DROP TABLE statements to the list of SQL queries).

[sand123]

Thank you Thomos,
I think it is always nice to take backup with(--add-drop-table)
option in mysqldump.
bcoz,it adds line
DROP TABLE IF EXITS;
🙂

Another Question:

I have to use autocommit and rollback in mysql.
but i think MySql does not support for that functions.

this is php_info()
MySQL
Support enabled
Active Persistent Links 0

Active Links 1

Client API version 4.0.22

MYSQL_MODULE_TYPE external

MYSQL_SOCKET /var/lib/mysql/mysql.sock

MYSQL_INCLUDE -I/usr/include/mysql

MYSQL_LIBS -L/usr/lib -lmysqlclient

after deleting some records from table i gave following command to restore the table.
but it showa the following error.
mysql> rollback;
ERROR 1196: Warning: Some non-transactional changed tables couldn't be rolled back

[tsinka]

If the tables are of type MyISAM then they don't support transactions at all. You need to create e.g. InnoDB (or BerkeleyD😎 tables in order to support transactions.

Thomas

[sand123]

bydefault table types are MyISAM.
can i change the type of table?

and then can i do the autocommit or rollback on table/database.