create database on unix

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk parsing file to create a database

Hi Guys, I have a list a hotels stored in many different text files. This list is kept in the following format: 20/03 Hotel: The Bear Hotel Honey Street Woodstock UK Tel:+44-xxxxxx Rate: 100 21/03 Hotel: The Bush Hotel Nice Street Farnham

2. AIX

Need a graphical interface on AIX server to create database

Hello, Please suggest me the ways how to get graphical interface on AIX server.I need to create oracle database for which I need graphical access. Best regards, Vishal

3. UNIX for Dummies Questions & Answers

Create Alert for Database Problem

Hi all, I new to scripting and i need to know how to put the script when the capture goes down in the feeds database.. I tried with this "ps -ef | grep asn" command and it displaying the capture,apply time. But the alert we are receving now is replication is failed . So i need to develop the...

4. Shell Programming and Scripting

Help with script to create users from database query

#!/bin/bash user=`mysql userList -uuserlist -puserlistpassword -s -N -e "SELECT userName FROM users WHERE activated='n'"` for i in $user; do useradd "$i" -m doneThis is what I have done so far. But obviously it still does not work. I'm trying to create users based on information stored in a...

5. Programming

Creating a bash script that create/open database

Hi. I have two text files(tables) which include some information and I want to make some query codes using them. First of all, I want to create bash script that read this two tables, create/open database and insert data from files into database. #!/bin/bash while read line; do ...

6. Shell Programming and Scripting

Create database using Backup file

Hi, I have backup file of database in my server. I want to create a that database in the same Mysql Server. How can I do that? Please send the steps to create the database using backup file? Thanks a lot,

7. Programming

Create a database in C

Hey, I have this basic server thing going on and I can't seem to allocate memory correctly and I can't access the memory after I allocated it. I was hoping people might suggest methods of doing this. I was thinking of using the socket file descriptor to reference the users.

8. Solaris

Can't create database after Oracle Database installation

I installed Oracle 10 software on Solaris 11 Express, everything was fine execpt I can't create database using dbca.rsp file. I populated file with following options. OPERATION_TYPE = "createDatabase" GDBNAME = "solaris_user.domain.com" SID = "solaris_user" TEMPLATENAME = "General...

9. Shell Programming and Scripting

Create mysql database with bash script - confused

Hi, i have the following: db="create database xxx;GRANT ALL PRIVILEGES ON xxx.* TO user@localhost IDENTIFIED BY 'password';FLUSH PRIVILEGES;quit;" mysql -u root -p$mysql_pass -e "$db" I don't understand why this is failing, it works fine when run from cmd but when is run in a bash script,...

10. UNIX for Advanced & Expert Users

trying to create a virtual database..

:cool: I like Vibhory2 like the idea of tapping into the kernel.. although not as indepth as he/she... i want to create a virtual databse of a few ma chines with connectivity and defiinte knowledge to create it.. I havebeen working on the project for a year now.. ! before unix (1 year exactly) i...

LEARN ABOUT PHP

fbsql_db_status

FBSQL_DB_STATUS(3)							 1							FBSQL_DB_STATUS(3)

fbsql_db_status - Get the status for a given database

SYNOPSIS

       int fbsql_db_status (string  $database_name, [resource  $link_identifier])

DESCRIPTION

	Gets the current status of the specified database.

PARAMETERS

	      o $database_name
		- The database name.

	      o $
		link_identifier  -A FrontBase link identifier returned by fbsql_connect(3) or fbsql_pconnect(3).If optional and not specified, the
		function will try to find an open link to the FrontBase server and if no such link is found it	will  try  to  create  one  as	if
		fbsql_connect(3) was called with no arguments.

RETURN VALUES

	Returns an integer value with the current status. This can be one of the following constants:

	      o FALSE - The exec handler for the host was invalid. This error will occur when the $link_identifier connects directly to a database
		by using a port number. FBExec can be available on the server but no connection has been made for it.

	      o FBSQL_UNKNOWN - The Status is unknown.

	      o FBSQL_STOPPED - The database is not running. Use fbsql_start_db(3) to start the database.

	      o FBSQL_STARTING - The database is starting.

	      o FBSQL_RUNNING - The database is running and can be used to perform SQL operations.

	      o FBSQL_STOPPING - The database is stopping.

	      o FBSQL_NOEXEC - FBExec is not running on the server and it is not possible to get the status of the database.

SEE ALSO

       fbsql_start_db(3), fbsql_stop_db(3).

PHP Documentation Group 													FBSQL_DB_STATUS(3)

UNIX for Advanced & Expert Users