Mysql commands - Revision history

Raj at 03:09, 9 August 2021

2021-08-09T03:09:22Z

@@ Line 30: / Line 30: @@
 >  GRANT ALL PRIVILEGES ON  *.* TO 'USER'@'localhsot';
 </source>
 [[Category:Bioinformatics]]

2021-08-02T09:51:07Z

First Time

← Older revision		Revision as of 09:51, 2 August 2021
Line 24:		Line 24:

	== First Time ==		== First Time ==
			<source>
	> apt install mysql-server		> apt install mysql-server
	> mysql_secure_installation		> mysql_secure_installation
	> CREATE USER 'USER'@'localhost' identified by 'PWD';		> CREATE USER 'USER'@'localhost' identified by 'PWD';
	> GRANT ALL PRIVILEGES ON . TO 'USER'@'localhsot';		> GRANT ALL PRIVILEGES ON . TO 'USER'@'localhsot';
			</source>
	[[Category:Bioinformatics]]		[[Category:Bioinformatics]]

2021-08-02T09:50:42Z

← Older revision		Revision as of 09:50, 2 August 2021
Line 19:		Line 19:
	* Create a soft Link		* Create a soft Link
	ln -s /home/copperhills/copperhills /var/www/copperhills		ln -s /home/copperhills/copperhills /var/www/copperhills



	</pre>		</pre>


			== First Time ==

			> apt install mysql-server
			> mysql_secure_installation
			> CREATE USER 'USER'@'localhost' identified by 'PWD';
			> GRANT ALL PRIVILEGES ON . TO 'USER'@'localhsot';

	[[Category:Bioinformatics]]		[[Category:Bioinformatics]]

2018-12-09T15:02:48Z

@@ Line 15: / Line 15: @@
 <pre>
 $ mysql -u $usr -p -h $host $db <$outfile
 </pre>
 [[Category:Bioinformatics]]

2010-01-03T18:49:17Z

2010-01-02T06:01:34Z

2010-01-02T06:01:13Z

2008-09-07T03:34:39Z

← Older revision		Revision as of 03:34, 7 September 2008
Line 1:		Line 1:
			* GetInto from Shell

			<pre>
			$ mysql -u $usr -p -h $host $db
			</pre>


	* GetDump		* GetDump
	<~~mysql~~>		<pre>
	$ mysqldump -u $usr -p -h $host $db >$outfile		$ mysqldump -u $usr -p -h $host $db >$outfile
	</~~mysql~~>		</pre>

	* RestoreDump		* RestoreDump

	<~~mysql~~>		<pre>
	$ mysql -u $usr -p -h $host $db <$outfile		$ mysql -u $usr -p -h $host $db <$outfile
	</~~mysql~~>		</pre>

2008-08-24T03:08:28Z

← Older revision		Revision as of 03:08, 24 August 2008
Line 1:		Line 1:
	* GetDump		* GetDump
	<~~pre~~>		<mysql>
	$ mysqldump -u $usr -p -h $host $db >$outfile		$ mysqldump -u $usr -p -h $host $db >$outfile
	</~~pre~~>		</mysql>

	* RestoreDump		* RestoreDump

	<~~pre~~>		<mysql>
	$ mysql -u $usr -p -h $host $db <$outfile		$ mysql -u $usr -p -h $host $db <$outfile
	</~~pre~~>		</mysql>

Raj: New page: * GetDump

 $ mysqldump -u $usr -p -h $host $db >$outfile

* RestoreDump

 $ mysql -u $usr -p -h $host $db <$outfile

2008-08-23T02:50:41Z

New page: * GetDump <pre> $ mysqldump -u $usr -p -h $host $db >$outfile </pre> * RestoreDump <pre> $ mysql -u $usr -p -h $host $db <$outfile </pre>

New page

* GetDump
<pre>
$ mysqldump -u $usr -p -h $host $db >$outfile
</pre>

* RestoreDump

<pre>
$ mysql -u $usr -p -h $host $db <$outfile
</pre>