create DataBase in java

[minakari]

I have a sql file ,how can I create DataBase in java I mean how can I restore my sql script with java code,isther any sample?

[r035198x]

I have a sql file ,how can I create DataBase in java I mean how can I restore my sql script with java code,isther any sample?

It's not yet clear (to me at least) what you really want to do.
By sql script do you mean a file that contains sql code?
And what do you mean by "restore my sql script"? Perhaps if you try to explain this again ...

[minakari]

It's not yet clear (to me at least) what you really want to do.
By sql script do you mean a file that contains sql code?
And what do you mean by "restore my sql script"? Perhaps if you try to explain this again ...

I hava a file that contains sql code,and I want use this file for create DataBase,but I dont now How can I do this in java?

[r035198x]

I hava a file that contains sql code,and I want use this file for create DataBase,but I dont now How can I do this in java?

So this file contains sql commands for creating a database? Does it have one sql commands or does it have many sql commands?
Which database are you using(MySQL, Oracle, e.t.c)?
Do you know how to use JDBC?

[minakari]

So this file contains sql commands for creating a database? Does it have one sql commands or does it have many sql commands?
Which database are you using(MySQL, Oracle, e.t.c)?
Do you know how to use JDBC?

this file has many sql commands,and DataBase Mysql or sq Server Or ...because I read connection information from a property file and the type of my Database isspecified in that file,because my application can connect to diffrent databases.

[r035198x]

this file has many sql commands,and DataBase Mysql or sq Server Or ...because I read connection information from a property file and the type of my Database isspecified in that file,because my application can connect to diffrent databases.

You could read each command one by one and execute them.
Do you know how to read a file using using a FileReader? How are your sql commands separated?

[minakari]

You could read each command one by one and execute them.
Do you know how to read a file using using a FileReader? How are your sql commands separated?

This is my sql file that I creat it by backup from my DataBase and I use MYSQL:

-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
--
-- Host: 172.25.1.220
-- Generation Time: Nov 05, 2007 at 04:08 PM
-- Server version: 5.0.22
-- PHP Version: 5.1.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `mpa`
--

-- --------------------------------------------------------

--
-- Table structure for table `authorities`
--

DROP TABLE IF EXISTS `authorities`;
CREATE TABLE IF NOT EXISTS `authorities` (
`username` varchar(50) NOT NULL default '',
`authority` varchar(50) NOT NULL default '',
UNIQUE KEY `ix_auth_username` (`username`,`authority`),
KEY `fk_authorities_users` (`username`),
KEY `dd` (`authority`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `authorities`
--


-- --------------------------------------------------------

--
-- Table structure for table `component_permission`
--

DROP TABLE IF EXISTS `component_permission`;
CREATE TABLE IF NOT EXISTS `component_permission` (
`ID` int(11) NOT NULL auto_increment,
`CompName` varchar(250) NOT NULL default '',
`CompPath` text,
`CopmIfNotGranted` varchar(250) default '',
`CopmIfAnyGranted` varchar(250) default '',
`CopmIfAllGranted` varchar(250) default '',
`CopmDescription` text,
`type` varchar(50) NOT NULL default 'DB',
PRIMARY KEY (`ID`),
UNIQUE KEY `CompName` (`CompName`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

--
-- Dumping data for table `component_permission`
--


-- --------------------------------------------------------

--
-- Table structure for table `favorits`
--

DROP TABLE IF EXISTS `favorits`;
CREATE TABLE IF NOT EXISTS `favorits` (
`uid` bigint(20) NOT NULL auto_increment,
`name` varchar(100) default NULL,
`uri` varchar(250) default NULL,
`userId` varchar(100) default NULL,
PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `favorits`
--


-- --------------------------------------------------------

--
-- Table structure for table `menu`
--

DROP TABLE IF EXISTS `menu`;
CREATE TABLE IF NOT EXISTS `menu` (
`id` int(11) NOT NULL auto_increment,
`url` text character set latin1 NOT NULL,
`parent_id` int(11) default '0',
`name` text character set utf8 collate utf8_swedish_ci NOT NULL,
`roles` text character set latin1 NOT NULL,
`sequence` int(11) default '0',
`type` varchar(25) character set latin1 NOT NULL default 'DB',
`description` text character set utf8 collate utf8_swedish_ci,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=27 ;

--
-- Dumping data for table `menu`
--


-- --------------------------------------------------------

--
-- Table structure for table `profiles`
--

DROP TABLE IF EXISTS `profiles`;
CREATE TABLE IF NOT EXISTS `profiles` (
`uid` bigint(20) NOT NULL,
`theme_id` bigint(20) default NULL,
PRIMARY KEY (`uid`),
KEY `FKC442ABEA7AB9F3E0` (`uid`),
KEY `FKC442ABEA1E53E5F5` (`theme_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `profiles`
--


-- --------------------------------------------------------

--
-- Table structure for table `related_menu`
--

DROP TABLE IF EXISTS `related_menu`;
CREATE TABLE IF NOT EXISTS `related_menu` (
`id` bigint(20) NOT NULL auto_increment,
`url` int(11) NOT NULL,
`relatedurl` text collate utf8_persian_ci NOT NULL,
`roles` text collate utf8_persian_ci NOT NULL,
`type` varchar(25) collate utf8_persian_ci NOT NULL,
`description` text collate utf8_persian_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_persian_ci AUTO_INCREMENT=7 ;

--
-- Dumping data for table `related_menu`
--


-- --------------------------------------------------------

--
-- Table structure for table `roles`
--

DROP TABLE IF EXISTS `roles`;
CREATE TABLE IF NOT EXISTS `roles` (
`role_name` varchar(50) NOT NULL,
PRIMARY KEY (`role_name`),
UNIQUE KEY `role_name` (`role_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `roles`
--



-- --------------------------------------------------------

--
-- Table structure for table `themes`
--

DROP TABLE IF EXISTS `themes`;
CREATE TABLE IF NOT EXISTS `themes` (
`uid` bigint(20) NOT NULL auto_increment,
`name` varchar(50) default NULL,
`description` varchar(100) default NULL,
PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `themes`
--


-- --------------------------------------------------------

--
-- Table structure for table `transusers`
--

DROP TABLE IF EXISTS `transusers`;
CREATE TABLE IF NOT EXISTS `transusers` (
`uid` bigint(20) NOT NULL auto_increment,
`userId` varchar(30) default NULL,
`name` varchar(100) default NULL,
`activated` tinyint(3) unsigned default NULL,
`creatingUser` varchar(255) default NULL,
`creatingDate` varchar(255) default NULL,
`creatingTime` varchar(255) default NULL,
`updatingUser` varchar(255) default NULL,
`updatingDate` varchar(255) default NULL,
`updatingTime` varchar(255) default NULL,
`deletingUser` varchar(255) default NULL,
`deletingDate` varchar(255) default NULL,
`deletingTime` varchar(255) default NULL,
`deleted` tinyint(3) unsigned default NULL,
`workGroup` varchar(255) default NULL,
PRIMARY KEY (`uid`),
UNIQUE KEY `userId` (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;

--
-- Dumping data for table `transusers`
--


-- --------------------------------------------------------

--
-- Table structure for table `url_permission`
--

DROP TABLE IF EXISTS `url_permission`;
CREATE TABLE IF NOT EXISTS `url_permission` (
`ID` bigint(20) NOT NULL auto_increment,
`name` varchar(256) NOT NULL,
`roles` text NOT NULL,
`description` text,
`type` varchar(25) NOT NULL default 'DB',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=121 ;

--
-- Dumping data for table `url_permission`
--

-- --------------------------------------------------------

--
-- Table structure for table `userfilters`
--

DROP TABLE IF EXISTS `userfilters`;
CREATE TABLE IF NOT EXISTS `userfilters` (
`uid` bigint(20) NOT NULL auto_increment,
`filterName` varchar(25) default NULL,
`filterDescription` varchar(100) default NULL,
`filterType` bigint(20) default NULL,
PRIMARY KEY (`uid`),
KEY `FKBB1285B0EFEB0934` (`filterType`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `userfilters`
--


-- --------------------------------------------------------

--
-- Table structure for table `userfiltertypes`
--

DROP TABLE IF EXISTS `userfiltertypes`;
CREATE TABLE IF NOT EXISTS `userfiltertypes` (
`uid` bigint(20) NOT NULL auto_increment,
`filterTypeName` varchar(30) default NULL,
`description` varchar(100) default NULL,
PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `userfiltertypes`
--


-- --------------------------------------------------------

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
`username` varchar(50) NOT NULL,
`password` varchar(50) NOT NULL default '',
`enabled` bit(1) NOT NULL default '\0',
PRIMARY KEY (`username`),
UNIQUE KEY `primerykey` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users`
--


-- --------------------------------------------------------

--
-- Table structure for table `user_filters`
--

DROP TABLE IF EXISTS `user_filters`;
CREATE TABLE IF NOT EXISTS `user_filters` (
`user_id` bigint(20) NOT NULL,
`filter_id` bigint(20) NOT NULL,
PRIMARY KEY (`user_id`,`filter_id`),
KEY `FK28003B8771F31D9F` (`user_id`),
KEY `FK28003B87DFFF4E6A` (`filter_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_filters`
--


--
-- Constraints for dumped tables
--

--
-- Constraints for table `profiles`
--
ALTER TABLE `profiles`
ADD CONSTRAINT `fkc442abea1e53e5f5` FOREIGN KEY (`theme_id`) REFERENCES `themes` (`uid`),
ADD CONSTRAINT `fkc442abea7ab9f3e0` FOREIGN KEY (`uid`) REFERENCES `transusers` (`uid`);

--
-- Constraints for table `userfilters`
--
ALTER TABLE `userfilters`
ADD CONSTRAINT `fkbb1285b0efeb0934` FOREIGN KEY (`filterType`) REFERENCES `userfiltertypes` (`uid`);

--
-- Constraints for table `user_filters`
--
ALTER TABLE `user_filters`
ADD CONSTRAINT `fk28003b8771f31d9f` FOREIGN KEY (`user_id`) REFERENCES `transusers` (`uid`),
ADD CONSTRAINT `fk28003b87dfff4e6a` FOREIGN KEY (`filter_id`) REFERENCES `userfilters` (`uid`);

[minakari]

You could read each command one by one and execute them.
Do you know how to read a file using using a FileReader? How are your sql commands separated?

I have backed up from my database and my back up file name is MPA.sql ,now I want create a new database with the name MPA2 ,so I want use MPA.sql in my java code and create my new database that this data base is exactly like the first database ,I DONT NOW HOW DO THAT ,is ther any sample ,can u help me?
could u anderstand my prolem?plz help me as it possible.

[dav3]

CLICK HERE

This website might help. I used this authors example as a base when creating my JDBC project.

[heat84]

Perhaps formating the text and reading each query from file will help. Learn more about reading from file.

[r035198x]

Perhaps formating the text and reading each query from file will help. Learn more about reading from file.

For backup and restoring a mysql database simply use Runtime.exec and pass it the appropriate commands
i.e for backup

 mysqldump -u yourUserName -pyourPassword yourDB > filename.sql

and

 mysql -u yourUserName -pyourPassword yourDB < filename.sql

for restoring